Microsoft KB Archive/918621

= All open workbooks are recalculated when you hide or unhide rows in Excel 2007 or in Excel 2003 =

Article ID: 918621

Article Last Modified on 7/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
When you hide or unhide rows in Microsoft Office Excel 2007 or in Microsoft Office Excel 2003, all open workbooks are recalculated. This problem may also occur when you group or ungroup rows, or when you use the Subtotal dialog box and then click OK.



CAUSE
This problem occurs when the calculation mode is set to Automatic.

In versions of Excel that are earlier than Excel 2003, workbooks are not recalculated when you hide and unhide rows. This change was made in Excel 2003 to improve support for the SUBTOTAL function. Excel 2003 recalculates workbooks in case dependent subtotals exist.

Note This recalculation does not occur when you hide and unhide columns.



WORKAROUND
To work around this problem, set the calculation mode to Manual. To do this, follow these steps.

Excel 2007
 * 1) Click the Microsoft Office Button, click Excel Options, and then click Formulas.
 * 2) In the Calculation options area, change the Workbook Calculation mode to Manual, and then click OK.

Excel 2003
 * 1) Click Options on the Tools menu.
 * 2) In the Options dialog box, click the Calculation tab.
 * 3) In the Calculation area, click Manual, and then click OK.

Note When you set the calculation mode to Manual, formulas are not recalculated automatically. This may cause the formulas to appear incorrect. To recalculate the formulas, press F9.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: subtotals

Keywords: kbtshoot kbperformance kbprb kbfunctions kbexpertisebeginner KB918621

-

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

© Microsoft Corporation. All rights reserved.