XL: Not Prompted to Save Changed Workbook When You Quit

• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

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.

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

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

   ARTICLE-ID: Q156883
   TITLE     : XL97: "Create Hyperlink Here" Does Not Work in Unsaved
               File

   ARTICLE-ID: Q156893
   TITLE     : XL97: Invalid Site Error Using Relative Hyperlink Path