Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. In Excel 2003 and in Excel 2002, you are prompted to save the changes when no changes were made

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

View products that this article applies to.

This article was previously published under Q289111

↑ Back to the top

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 Filename.xls?

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

↑ Back to the top

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.

↑ Back to the top

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.
  2. Click the Calculation tab. Under Calculation, click Manual. Click to clear the Recalculate before save check box.
  3. Click OK.

↑ Back to the top

Keywords: KB289111, kbprb, kbconversion

↑ Back to the top

Article Info
Article ID : 289111
Revision : 4
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 269