Article ID: 174868
Article Last Modified on 1/9/2007
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q174868
SUMMARY
In Microsoft Excel 97 and Microsoft Excel 97 Service Release 1 (SR-1), worksheet values may not be recalculated correctly when certain conditions are true. To correct this problem, Microsoft has developed the Excel 97 Auto-Recalculation Patch for use with Microsoft Excel 97 SR-1.
This problem was also corrected in Microsoft Office 97 Service Release 2 (SR-2). Office 97 SR-2 incorporates the fixes included in the Excel 97 Auto-Recalculation Patch.
For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:
151261 OFF97: How to Obtain and Install MS Office 97 SR-2
This article contains information about the problems that are corrected by the Excel 97 Auto-Recalculation Patch. To correct this problem, download and install the latest update for Excel 97. The latest update includes this and all other Excel-specific updates that have been released since the latest service release (SR) of Office. The files included in this update will be included in any later SR or patch. To upgrade to the latest patch or for more information about the history of Excel 97 patches, please click the article number below to view the article in the Microsoft Knowledge Base:
232652 XL97: Overview and History of Excel Patches
MORE INFORMATION
What Does the Excel 97 Auto-Recalculation Patch Correct?
This patch corrects several problems that may occur when you use automatic calculation in Microsoft Excel 97. For more information and specific examples of the problems that the Excel 97 Auto-Recalculation Patch resolves, please see the following articles in the Microsoft Knowledge Base:
171339 XL97: Some Values Not Recalculated When Using Multiple Formulas
154134 XL97: Functions in Filled Formulas May Not Be Recalculated
182999 XL97: Chart Data Labels That Are Linked to Formulas Are Not Updated
Additional query words: XL97 sr1 recalc calc
Keywords: kbfaq kbhowto KB174868
