Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: "Incomplete Calculation" Error When You Open File Linked to Exported Access Table

XL2000: "Incomplete Calculation" Error When You Open File Linked to Exported Access Table

View products that this article applies to.

This article was previously published under Q284210

↑ Back to the top

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.

↑ Back to the top

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).

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB284210, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 284210
Revision : 4
Created on : 1/6/2006
Published on : 1/6/2006
Exists online : False
Views : 202