Article ID: 174868 - View products that this article applies to.
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 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:
151261This 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:
(https://support.microsoft.com/kb/151261/EN-US/ )OFF97: How to Obtain and Install MS Office 97 SR-2
(https://support.microsoft.com/kb/232652/EN-US/ )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 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:
(https://support.microsoft.com/kb/171339/EN-US/ )XL97: Some Values Not Recalculated When Using Multiple Formulas
(https://support.microsoft.com/kb/154134/EN-US/ )XL97: Functions in Filled Formulas May Not Be Recalculated
(https://support.microsoft.com/kb/182999/EN-US/ )XL97: Chart Data Labels That Are Linked to Formulas Are Not Updated