Microsoft KB Archive/284210

= XL2000: &quot;Incomplete Calculation&quot; Error When You Open File Linked to Exported Access Table =

Article ID: 284210

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q284210





SYMPTOMS
If you export a table from Microsoft Access 2000 to Microsoft Excel format, and then link from a new file to the resulting workbook, when you open the linked workbook and update links, you receive the following error message:

Links to  were not updated because   was not recalculated before it was last saved.



CAUSE
This error message occurs due to a problem with the Excel indexed sequential access method (ISAM) driver that is included with Microsoft Office 97, Service Release 2 (SR-2).



WORKAROUND
To work around this problem, open the exported Excel file in Excel, press CTRL+ALT+F9 to recalculate, and then save the file. You can now open the linked file without errors.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem is scheduled to be corrected in a future version of the ISAM driver.

Additional query words: XL2000

Keywords: kbbug kbpending KB284210

-

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

© Microsoft Corporation. All rights reserved.