XL97: Links In Microsoft Excel 4.0 Workbooks Are Incorrect

Last reviewed: February 12, 1998
Article ID: Q165568
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you open a Microsoft Excel 4.0 workbook (containing bound worksheets) in Microsoft Excel 97, the links between worksheets may not point to the correct source worksheet(s). The links may refer to the worksheet name that the formula exists on instead of to the worksheet name the links were using when they were created.

NOTE: You will not experience this behavior if you are linking between Microsoft Excel 4.0 workbooks. This only happens when you are linking between worksheets within a Microsoft Excel 4.0 workbook.

RESOLUTION

To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).

To work around this problem, you can use Microsoft Excel versions 5.x or 7.x to open the Microsoft Excel 4.0 workbook and save it in a current workbook format. To do this, follow these steps:

  1. Open the Microsoft Excel 4.0 workbook in Microsoft Excel versions 5.x or 7.x.

  2. On the File menu, click Save As.

  3. In the Save As Type box, select Microsoft Excel Workbook (*.xls) and click Save.

You can open the workbook in Microsoft Excel 97, and the links are updated correctly.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97. This problem was corrected in Microsoft Excel 97 SR-1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q172475
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-1

REFERENCES

For more information about updating links, click the Index tab in Microsoft Excel 97 Help, type the following text

   linking, cells in worksheets and workbooks

and then double-click the selected text to go to the "Update references to a workbook that has been renamed or moved" topic.


Additional query words: XL97 xlw sr1
Keywords : xlformula xlloadsave
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbfix


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