Microsoft KB Archive/210162

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

Article ID: 210162

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q210162



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 ?

Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel.

where  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.

