Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 172640 - Last Review: January 20, 2007 - Revision: 2.1
OFF97: Workbook Changed by MS Access May Not Be Recalculated
This article was previously published under Q172640
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!A1
the 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:
- In Microsoft Access 97, you create a link table that links to a
worksheet in a Microsoft Excel workbook.
-and-
- By using Microsoft Access 97, you change a value (or values) in the link
table.
-and-
- You open the workbook in Microsoft Excel 97.
-and-
- One or more formulas in the workbook refer to the changed values.
To work around this problem, follow these steps:
- In Microsoft Excel 97, open the workbook.
- Press CTRL+ALT+F9.
The values in the workbook are recalculated. If you make additional changes
to the workbook in Microsoft Excel 97, Microsoft Excel continues to
recalculate the values properly. If you use Microsoft Access 97 to make
additional changes to the workbook, you must use the workaround when you
reopen the workbook in Microsoft Excel 97.
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.
APPLIES TO
- Microsoft Office 97 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please