Excel: Save As Dialog Appears when Closing Unchanged File

 Last reviewed: November 4, 1994
Article ID: Q82893
The information in this article applies to:
  • Excel for Windows version 3.0
  • Excel for the Macintosh version 3.0

Summary:

Closing a spreadsheet saved under an optional file format may bring up the "Save Changes in [worksheet name]?" query even if the file is closed immediately after saving. This applies to files saved in all formats except Normal, Template, WKS, WK1, WK3.

More Information:

Excel brings up the Save As dialog box if the format used when the file was last saved might result in the loss of data. This is intended to serve as an extra safeguard against the loss of information.

This information applies to spreadsheets that have been created or changed in the current Excel session. Any document may be opened and closed without the "Save Changes in [worksheet name]?" query if no changes have been made to the file, no matter what its file format.

Note: If the file format is Excel 2.x, clicking "Yes" in response to the "Save Changes" query brings up the Save As dialog box with the file format set to Normal. If the document is saved at this point, Excel converts the file back to Normal (Excel 3.0) file format.

References:

"Microsoft Excel User's Guide" for the Macintosh, version 3.0, pages 132-133

"Microsoft Excel User's Guide" for Windows, version 3.0, pages 138-139

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00 SYLK DBF2 DBF3 CSV Text DIF



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 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.