Article ID: 172640 - View products that this article applies to.
This article was previously published under Q172640
This article has been archived. It is offered "as is" and will no longer be updated.
When you open a workbook in Microsoft Excel 97, some formulas in the workbook may not be recalculated properly. For example, if cell B5 in Sheet2 contains the following formula
=Sheet1!A1the formula may return a value that was previously in Sheet1!A1 instead of the value that is currently in Sheet1!A1.
This problem occur if all of the following conditions are true:
To work around this problem, follow these steps:
Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
In Microsoft Excel 97, when a workbook must be recalculated, a record named "RTUNCALCED" is written in the workbook. Microsoft Excel clears this record when the workbook is recalculated; if the record is not present, Microsoft Excel 97 does not recalculate the values in workbook.
When you make a change to a link table in Microsoft Access 97, the change is written to the table in the external file. However, if the external file is a Microsoft Excel workbook, Microsoft Access 97 does not write the RTUNCALCED record in the workbook. As a result, when you open the workbook in Microsoft Excel 97, the workbook is not automatically recalculated, and formulas in the workbook may return incorrect values.
Note that this problem does not occur when you change a link table in earlier versions of Microsoft Access.
Article ID: 172640 - Last Review: October 7, 2013 - Revision: 2.1