General discussion

Locked

Slow to open Excel document

By Net Designer ·
Windows XP SP2 (+all latest updates)
Office 2000 (with all latest MS updates)
Excel document created in MS Office 2000

It takes about 15-20 minutes to open Excel document. After it finally opens, a message tells us that excel re-calculates all formulas in document prior to opening it as the document was created in previous version of excel when it wasn't. After re-Saving As again-and-again in 2000 format, and closing the document, it still takes 15-20 minutes to open.
Document opens fine if Office 97 is used.
The problem occurs on any PC if office2k is used.
It doesn't matter if document is on local or network drive.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Oz_Media In reply to Slow to open Excel docume ...

Hmmm, the save issue was supposed to be fixed in SP1a.

There are known issues with the way old formulas are calculated and MS offer some tips on optimizing Excel docs and the formula layouts to speed recalculation.

http://support.microsoft.com/default.aspx?scid=kb;en-us;72622

Collapse -

by Net Designer In reply to

Poster rated this answer.

Collapse -

by Net Designer In reply to Slow to open Excel docume ...

Problem was solved by copy/paste into a new workbook.

Collapse -

by Net Designer In reply to Slow to open Excel docume ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums