Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion

Gravatar
0 Votes
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
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

gravatar
Collapse -

by Net Designer In reply to

Poster rated this answer.

gravatar
Collapse -

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

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

gravatar
Collapse -

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

This question was closed by the author

Back to Software Forum

Start or search

Related Discussions

Related Forums