Microsoft KB Archive/813977

= You receive a message when you try to open a Microsoft Excel workbook: &quot;This workbook contains one or more links that cannot be updated&quot; =

Article ID: 813977

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
When you try to open a Microsoft Excel workbook, you may receive a message that resembles one of the following messages, depending on the version of Excel that you are running.

Microsoft Office Excel 2007
Security Warning Automatic update of links has been disabled.

If you click Options, click Enable this content, and then click OK, you receive the following message:

Excel cannot update one or more links in this workbook. To update the links, open all the link source files (click Edit Links on the Data tab). To be sure all calculations are updated, press F9.

To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

101006

When you click OK, you then receive the following message:

This workbook contains one or more links that cannot be updated.


 * To change the source of links, or attempt to update values again, click Edit Links.


 * To leave the links as is, click Continue.

To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:

101120

Microsoft Office Excel 2003
This workbook contains links to other data sources.


 * If you update the links, Excel attempts to retrieve the latest data.


 * If you don't update, Excel uses the previous information.

If you click Update, you receive the following error message:

This workbook contains one or more links that cannot be updated.


 * To change the source of links, or attempt to update values again, click Edit Links.


 * To open the workbook as is, click Continue.



CAUSE
This issue may occur if the workbook that you want to open has links to a closed workbook that is saved in the HTML file format.



WORKAROUND
To work around this issue, open the HTML file that the workbook is linked to before you try to open the workbook that contains the links.



MORE INFORMATION
Excel cannot update links from a workbook that is saved in HTML file format if that workbook is closed. Excel updates the links correctly only if the link source file is already opened.



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: OfficeErrorMessages 10032 XL2003 XL2007

Keywords: kbofficealertid kbexpertisebeginner kbbug kberrmsg KB813977

-

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

© Microsoft Corporation. All rights reserved.