Microsoft KB Archive/176700

= 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.



MORE INFORMATION
For more information about problems with hyperlinks and unsaved workbooks, please see the following articles in the Microsoft Knowledge Base:

156883 XL97: "Create Hyperlink Here" Does Not Work in Unsaved File

156893 XL97: Invalid Site Error Using Relative Hyperlink Path

Additional query words: XL97 shutdown shut down XL

Keywords: kbprb KB176700

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.