Microsoft KB Archive/171239

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Article ID: 171239

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q171239

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:

172475 ff: 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: kbbug kbfix KB171239