Error opening workbook containing links to HTML workbook in Excel

View products that this article applies to.

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