XL97: Links in Shared Workbook Return #REF! Error
Article ID: 165167
Article Last Modified on 3/28/2001
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q165167
For a Microsoft Excel 2002 version of this article, see
291287.
For a Microsoft Excel 2000 version of this article, see
211449.
For a Microsoft Excel 98 version of this article, see
181902.
SYMPTOMS
When you save a shared workbook, links to external documents may return the
#REF! error.
CAUSE
This problem occurs when the following conditions are true:
- Another user opens the shared workbook, creates a new link, and then
saves the file.
-and-
- You open the shared workbook and save the file.
WORKAROUND
To update the links, use the following steps:
- On the Edit menu, click Links.
- Click the linked workbook you want to update and click Update Now.
- Click Close
REFERENCES
For more information about updating links in shared workbooks, click the
Index tab in Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "The links in my
shared workbook don't work." topic.
Additional query words: XL97 8.00
Keywords: kbbug kbnofix kbweb KB165167