Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171239

From BetaArchive Wiki
Knowledge Base

Article ID: 171239

Article Last Modified on 10/22/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q171239


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.


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.


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

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


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


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