Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening Excel Doc With Links Very Slow

Status
Not open for further replies.

Pocket

MIS
Oct 5, 2001
20
GB
Hi,

We have a problem with Windows 2000 Professional workstations. We have several Excel spreadsheets with a large number of links in them. If you open them on a Windows 2000 Professional workstation, the machine appears to lock up. It will eventually come back to life, but it literally takes 4-5 minutes to open the document.

On a Windows 98 machine, the document opens immediately.

The spreadsheets we're using are a series of documents that are created monthly. Each spreadsheet links back to the previous month, so there are literally hundreds - possibly thousands - of links going back several years.

One theory is that Windows 2000 Pro is being more thorough about checking these links than Excel, and is going back through every single document, whereas 98 only checks back to the last document. But that doesn't help me solve the problem!

Does anyone have any ideas, or has anyone seen a similar problem?
 
Which service pack are you running?

Things speeded up for us after we upgraded the SR pack.

Indu
 
I am sorry I couldn't tell you before which service pack fixed it for us. I had forgotten. Age does that to you.

Anyway, it's SR-1a that did the trick.

HTH

Indu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top