XL97: Changes Not Saved When Workbook Is Opened in MS Outlook

Last reviewed: December 11, 1997
Article ID: Q177970
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Outlook 97
  • Microsoft Windows NT Workstation version 4.0

SYMPTOMS

When you attempt to save a workbook in Microsoft Excel 97 for Windows, you may receive an error message similar to the following

   Your changes could not be saved to '<Filename.xls>', but were saved to
   a temporary document named '<Hexadecimal>'. Close the existing
   document, then open the temporary document and save it under a new
   name.

where <Filename.xls> is the name of the workbook (for example, Book1.xls) and <Hexadecimal> is a hexadecimal string (for example, AEF345D).

CAUSE

This problem may occur when the following conditions are true:

  • You have installed Microsoft Excel 97 and Microsoft Outlook 97 on a computer that is running Microsoft Windows NT Workstation, version 4.0.

    -and-

  • In Microsoft Outlook 97, you open a Microsoft Excel workbook by following these steps:

        1. On the Outlook Bar, click Other. Then, click either My Documents
           or My Computer.
    

        2. In the right pane, double-click the Microsoft Excel workbook that
           you want to open.
    

    -and-

  • The workbook contains one or more Visual Basic for Applications modules, class modules, or UserForms.

    -and-

  • You save the workbook by clicking Save or Save As on the File menu.

When this problem occurs, the original workbook (Book1.xls) is not saved, but the new workbook (AEF345D) remains intact.

NOTE: This problem does not occur on a computer running Microsoft Windows 95.

WORKAROUND

To work around this problem, rename the new workbook to use the original workbook name by using either of the following methods.

Renaming a File in Microsoft Outlook

To rename the file, follow these steps:

  1. On the Outlook Bar, click Other. Then, click either My Documents or My Computer.

  2. In the right pane, select the workbook with the hexadecimal name.

  3. On the File menu, click Rename.

  4. Enter the correct name of the workbook with the file name extension (for example, Book1.xls). Then, click OK.

Renaming a File in Windows Explorer

  1. Start Microsoft Windows Explorer and go to the folder in which you stored the original workbook (for example, C:\My Documents).

  2. Select the workbook with the hexadecimal name.

  3. On the File menu, click Rename.

  4. Enter the correct name of the workbook with the file name extension (for example, Book1.xls). Press ENTER.

To prevent this problem from occurring, open workbooks from within Microsoft Excel 97 either by clicking Open on the File menu or by double- clicking them in Windows Explorer.

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 additional information about the error message in the "Symptoms" section, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q113600
   TITLE     : XL: Cannot Rename to '<File name>' Saving to Network Drive


Additional query words: XL97 OL97
Keywords : xlloadsave xlvbainfo kberrmsg
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


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: December 11, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.