Microsoft KB Archive/289111

= In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made =

Article ID: 289111

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q289111



SYMPTOMS
When you open a workbook and then close it with out making any changes, you are prompted as follows:

Do you want to save the changes to ?

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



CAUSE
By default, Microsoft Office Excel 2003 and Microsoft Excel 2002 recalculate files that were last saved in an earlier version of Excel. This ensures that any improvements made to the Excel calculation engine are applied to all formulas in the workbook.



RESOLUTION
To prevent Excel 2003 or Excel 2002 from automatically recalculating workbooks saved in earlier versions, follow these steps:
 * 1) On the Tools menu, click Options.

NOTE: The Options command is only available when a workbook is open. If it is not available, click New on the File menu, and then click Blank Workbook in the New Workbook task pane.
 * 1) Click the Calculation tab. Under Calculation, click Manual. Click to clear the Recalculate before save check box.
 * 2) Click OK.

Keywords: kbconversion kbprb KB289111

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.