Microsoft KB Archive/242237

= Worksheet may not recalculate completely when you repeatedly press F9 =

Article ID: 242237

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q242237



SYMPTOMS
When you press F9 to recalculate your worksheet in Microsoft Excel, the formulas in your worksheet may appear to calculate incorrect values.



CAUSE
This issue occurs when you repeatedly press or hold down F9 to recalculate your worksheet. By design, Excel halts the recalculation of your worksheet when you press a key on your keyboard. Under normal circumstances, you may never notice this behavior. However, this behavior may appear to be a problem when you are using circular references in your worksheet.

Note When you press CTRL, SHIFT, or PRINT SCREEN, the calculation process is not halted.



WORKAROUND
To prevent this issue, press F9 and do not press any other key on your keyboard until Excel has completely recalculated your worksheet.

Additional query words: XL2000 XL XL2002 XL2003 XL2007

Keywords: kbenablelearn kbenablemove kbenablesight kbprb KB242237

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.