MS Excel 97 Auto Recalculation Issue

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

About the Updated Patch:

The updated Excel 97 for Windows Auto-Recalculation Patch resolves the recalculation issues discovered in Microsoft Excel 97 for Windows, including the issues related to shared formulas. If you have downloaded a version of the Excel 97 for Windows Auto-Recalculation Patch prior to April 22, 1998, you should still download this latest patch to ensure that your worksheets automatically recalculate correctly. If you are not sure whether you already have this latest patch, you can safely download it, as the download will automatically stop and display a message stating that you have this version if it was previously installed on your computer. Similarly, if you have an earlier version of this patch, this download will only make the changes your Excel program still requires.

More Information:

For additional information on this subject, see the following Knowledge Base articles:

  • "Functions in Filled Formulas May Not Be Recalculated" Article ID: 154134

  • "Some Values Not Recalculated When Using Multiple Formulas" Article ID: 171339

  • "How to Obtain the Excel 97 Auto Recalculation Patch" (includes information for system administrators). Article ID: 174868

  • "Chart Data Labels Linked to Formulas Are Not Updated" Article ID: 182999

Before You Install This Patch:

To use the updated English version of the Excel 97 Auto-Recalculation Patch, you must be running Excel 97 Service Release 1 (SR-1). To verify which version of Excel you are running, on the Excel Help menu, click About Microsoft Excel. You should see Microsoft Excel 97 SR-1 as your version of Excel. If the version you are running is not Microsoft Excel 97 SR-1, please go to the Office 97 Service Release 1 information page for instructions on obtaining Excel 97 SR-1 (which is included in Office 97 SR-1).

Click here to access xl8patch.exe

Information for Users of International Versions of Excel 97:

The automatic recalculation issues affect all versions of Excel 97 for Windows, including international versions. If you are using a version of Excel 97 Service Release 1 other than the English or the International English version, many localized versions of the updated patch are underway.

NOTE to Microsoft Windows 98 beta testers This updated patch does work in conjunction with the Windows 98 beta, but requires specific installation instructions. If you are running the Windows 98 beta, make sure you read the Windows 98 beta user instructions before downloading and running the patch.

Installation Instructions:

  1. Ensure that you have installed the Office 97 SR-1 Patch. (Confirm this in Excel by clicking the About Microsoft Excel command on the Help menu. You should see Microsoft Excel 97 SR-1 as your version of Excel.)

  2. Ensure that you have 5 megabytes (MB) of hard-disk space available before beginning the installation.

  3. Close any open Windows applications.

  4. Install the patch to your computer's hard disk by clicking on the "Click Here" button.

  5. Select whether you want to Run this program from its current location or Save this program to disk.

    If you save it to disk, you must double-click the xl8patch.exe, saved in the hard-disk location you specified, to begin installation.

  6. You will be prompted for a location to install the file. By default, the file is installed in C:\Program Files\Microsoft Office\Office

  7. If you want to run the patch on your Excel program now, click Yes when prompted.

    If you want to run the patch at a later time, double-click the xl8p3.exe file you installed in the location you chose in step 6.

Note: Once you have run the updated Excel 97 Auto-Recalculation Patch, Excel 97 worksheets that exhibited the problem may not recalculate automatically the first time they are opened. To apply the fix, press Ctrl+Alt+F9 with a worksheet open. The next time you open it, the worksheet will recalculate automatically as expected.