Article ID: 291084 - Last Review: January 31, 2007 - Revision: 2.1

Error opening workbook containing links to HTML workbook in Excel

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q291084
Expand all | Collapse all

SYMPTOMS

When you open a workbook in Microsoft Excel, you may receive the following error message:
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.
Back to the top

CAUSE

Excel cannot update links from a workbook that is saved in the HTML file format if that workbook is closed.

Excel updates the links correctly if the link source file is already opened.
Back to the top

WORKAROUND

To work around this behavior, open the HTML file to which the workbook is linked before you update links in the workbook.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Back to the top
Keywords: 
kberrmsg kbbug kbpending KB291084
Back to the top