XL97: MS Excel Does Not Resume Calculation After Halting

ID: Q171239

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

Microsoft Excel 97 stops calculating formulas in a workbook even though you are using automatic calculation. Microsoft Excel 97 fails to resume calculating formulas after a few seconds of inactivity.

CAUSE

This problem may occur when you perform one of the following actions while Microsoft Excel is recalculating formulas:

You select a cell or a range of cells.
```
    -or-
```
You switch to a different worksheet.
```
    -or-
```
You switch to a different workbook.
```
    -or-
```
You click a menu item.
```
    -or-
```
You click a toolbar button.
```
    -or-
```
You move or resize a window.
```
    -or-
```
You start the Microsoft Office Assistant.

RESOLUTION

To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).

To work around this problem, press F9 and resume calculation.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97. This problem was corrected in Microsoft Excel 97 SR-1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q172475
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-1

REFERENCES

For more information about calculating workbooks, click the Index tab in Microsoft Excel Help, type the following text

   calculation, overview

and then double-click the selected text to go to the "About calculation in workbooks" topic.

Additional query words: XL97 recalc activate not updated sr1

Keywords          : xlformula 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: November 5, 1998