Excel: Iteration and Calculation Settings Are Reset

 Last reviewed: November 30, 1994
Article ID: Q44275
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

In Microsoft Excel, the default settings for Iteration and for the Calculation options in the Options Calculation dialog box are determined by the first sheet you open (typically, this sheet is Sheet1, an unsaved worksheet). If the first sheet you open is Sheet1, the calculation options will be set to the default settings: the Automatic option is selected for Calculation and the Iteration check box is cleared. Any sheets opened in addition to Sheet1 will have these same calculation settings. However, if you close Sheet1 and then open a sheet with different settings (for example a sheet called MYSHEET.XLS), all sheets that you open subsequently will have the same settings as that sheet (for example, all files will have the same settings as MYSHEET.XLS).

MORE INFORMATION

To successfully open a sheet with saved calculation settings, you must first close all open sheets. Your sheet will then open with the saved settings.

KBCategory: kbusage
KBSubcategory:

Additional words: 5.00 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 4.00a

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.