Microsoft KB Archive/181902

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

Article ID: 181902

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181902



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 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

