Microsoft KB Archive/211449

= XL2000: Links in Shared Workbook Return #REF! Error =

Article ID: 211449

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211449



For a Microsoft Excel 2002 version of this article, see 291287.

For a Microsoft Excel 98 version of this article, see 181902.

For a Microsoft Excel 97 version of this article, see 165167.



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.

