XL97: How to Obtain the Excel 97 Auto Recalculation Patch

Article translations Article translations
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.
Expand all | Collapse all

On This Page

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

Properties

Article ID: 174868 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbhowto KB174868

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com