XL2000: Error Opening Workbook Containing Links to HTML Workbook

ID: Q221082

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you open a workbook, you may receive the following message:

The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?

To update all linked information, click Yes.
To keep the existing information, click No.

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

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

NOTE: Excel updates the links correctly if the link source file is already opened.

CAUSE

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

WORKAROUND

To work around this behavior, open the HTML file to which the workbook is linked before updating links in the workbook.

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug