Microsoft KB Archive/165167

= 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:
 * 1) On the Edit menu, click Links.
 * 2) Click the linked workbook you want to update and click Update Now.
 * 3) Click Close

