Microsoft KB Archive/291287

= Links in shared workbook return #REF! error in Excel =

Article ID: 291287

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q291287





For a Microsoft Excel 2000 version of this article, see 211449.



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.
 * You open the shared workbook and then save the file.



WORKAROUND
To update the links, follow these steps:
 * 1) In Microsoft Office Excel 2003 or in Microsoft Excel 2002, click Links on the Edit menu.

In Microsoft Office Excel 2007, click the Data tab, and then click Edit Links in the Connections group.
 * 1) Click the linked workbook that you want to update, and then click Update Values.
 * 2) Click Close.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2002 XL2003 XL2007

Keywords: kbbug kbpending kbweb KB291287

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.