Microsoft KB Archive/291084

= Error opening workbook containing links to HTML workbook in Excel =

Article ID: 291084

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q291084





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.



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.



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



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

Keywords: kberrmsg kbbug kbpending KB291084

-

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

© Microsoft Corporation. All rights reserved.