XL: Not Prompted to Save Changed Workbook When You Quit

ID: Q176700

The information in this article applies to:

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.

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:

   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

Additional query words: XL97 shutdown shut down

Keywords          : xlloadsave xlweb 
Version           : WINDOWS:97; MACINTOSH:98
Platform          : MACINTOSH WINDOWS
Issue type        : kbprb

Last Reviewed: January 8, 1999