XL2000: "Incomplete Calculation" Error When You Open File Linked to Exported Access Table (284210)
The information in this article applies to:
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 filename were not updated because filename 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.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
|---|
| Keywords: | kbbug kbpending KB284210 |
|---|
|