Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error opening workbook containing links to HTML workbook in Excel


View products that this article applies to.

This article was previously published under Q291084

↑ Back to the top


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


Keywords: KB291084, kbpending, kbbug, kberrmsg

↑ Back to the top

Article Info
Article ID : 291084
Revision : 3
Created on : 1/31/2007
Published on : 1/31/2007
Exists online : False
Views : 275