Workbook loads slowly the first time that it is opened in Excel

Article translations Article translations
Article ID: 210162 - View products that this article applies to.
This article was previously published under Q210162
Expand all | Collapse all

SYMPTOMS

When you open a file in Microsoft Excel for the first time, the file may take more time than normal to load.

Also, when you close the file, you may receive the following prompt:
Do you want to save the changes you made to Filename?

Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel.
where filename is the name of the file that you are closing.

CAUSE

The first time you open a file that was last saved in a previous version of Excel, the file is completely recalculated.

Note If Excel is in manual calculation mode, the file is not recalculated.

RESOLUTION

After you save the workbook in the later version of Excel, the workbook will take less time to open on subsequent tries.

REFERENCES

For more information about Excel fully recalculating workbooks when they are opened for the first time, click Microsoft Excel Help on the Help menu, type About the way Excel recalculates workbooks that were created in earlier versions in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Note This help topic incorrectly states that all workbooks created in an earlier version of Excel will be fully recalculated when they are opened. Only workbooks that were last saved in Excel 97 or later are fully recalculated.

Properties

Article ID: 210162 - Last Review: January 23, 2007 - Revision: 3.3
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kbprb KB210162

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com