Excel: Closing Workbook Results in Multiple Prompts to Save

Last reviewed: November 30, 1994
Article ID: Q86162
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS

When you close a workbook in Microsoft Excel version 4.0, you may receive multiple prompts to save some or all of the individual sheets of the workbook (even when no apparent changes have been made).

CAUSE

This situation will occur if any of the sheets in a workbook contain volatile functions [for example, NOW() or RAND()] or links to other sheets that contain volatile functions, and if the Calculation option is set to Automatic.

If Calculation is set to Automatic, volatile functions will be recalculated when the workbook is opened and, as a result, Microsoft Excel marks affected sheets as changed, and you are prompted to save these changes for each sheet in the workbook that contains either a volatile function or a link to another sheets that contains a volatile function.

WORKAROUND

To avoid receiving these individual prompts, save the workbook before you close it by choosing Save Workbook from the File menu.

STATUS

This behavior is by design.

MORE INFORMATION

In Microsoft Excel, the volatile functions include the following:

       AREAS()           INDEX()             OFFSET()
       CELL()            INDIRECT()          ROWS()
       COLUMNS()         NOW()               RAND()

REFERENCES

"User's Guide 1," version 4.0, pages 67-70


KBCategory: kbusage
KBSubcategory:

Additional reference words: recalculate 4.00 recalc


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.