Not Prompted to Save Changed Workbook When You Quit
Article ID: 176700
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q176700
SYMPTOMS
In Microsoft Excel 97 for Windows, if you click Exit on the File menu or
if you press ALT+F4, Microsoft Excel may quit without prompting you to
save changes to unsaved workbooks.
The same problem may occur in Microsoft Excel 98 Macintosh Edition if
you click Quit on the File menu or if you press COMMAND+Q.
CAUSE
This problem may occur when the following conditions are true:
- You insert a hyperlink in a new workbook by clicking Hyperlink on
the Insert menu. When you are prompted to save the workbook, you click
No or Don't Save.
-and-
- You click the hyperlink. When you are again prompted to save the
workbook, you click No or Don't Save.
-and-
- You switch back to Microsoft Excel.
-and-
- You click Exit on the File menu or press ALT+F4 in Microsoft Excel for
Windows, or you click Quit on the File menu or press COMMAND+Q in
Microsoft Excel for the Macintosh.
The changes to the workbook are not saved, however, when Microsoft Excel
quits, you do not have the opportunity to save the workbook.
RESOLUTION
To resolve this problem, save the workbook when you are prompted by
Microsoft Excel. Insert hyperlinks only in workbooks that you saved at
least once.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: XL97 shutdown shut down XL
Keywords: kbprb KB176700