This article was previously published under Q174868
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel 97 and Microsoft Excel 97 Service Release 1 (SR-1),worksheet values may not be recalculated correctly when certain conditionsare true. To correct this problem, Microsoft has developed the Excel 97Auto-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 articlein 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 bythe 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
What Does the Excel 97 Auto-Recalculation Patch Correct?
This patch corrects several problems that may occur when you use automaticcalculation in Microsoft Excel 97. For more information and specificexamples of the problems that the Excel 97 Auto-Recalculation Patchresolves, please see the following articles in the Microsoft KnowledgeBase:
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