Microsoft KB Archive/839951

= Excel may appear to endlessly loop calculating cells when you insert several subtotals in a workbook =

Article ID: 839951

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003

-



SYMPTOMS
When you insert several subtotals in a Microsoft Excel workbook, Excel may appear to endlessly loop calculating cells.



CAUSE
This behavior may occur because Excel recalculates once for each subtotal that is inserted in a workbook.



WORKAROUND
To work around this behavior, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

 * 1) Click the Formulas tab.
 * 2) Click Calculation Options in the Calculation group, and then click Manual.
 * 3) Select the cell in which you want the subtotal to appear.
 * 4) Click Math & Trig in the Function Library group, and then click SUBTOTAL.
 * 5) In the Function Arguments dialog box, make the changes that you want, and then click OK.
 * 6) After you have inserted all the subtotals that you want into the workbook, click Calculation Options in the Calculation group, and then click Automatic.

Microsoft Office Excel 2003

 * 1) On the Tools menu, click Options.
 * 2) On the Calculation tab, click Manual.
 * 3) Click OK.
 * 4) Select the cell in which you want the subtotal to appear.
 * 5) On the Data menu, click Subtotals.
 * 6) In the Subtotal dialog box, make the changes that you want, and then click OK.
 * 7) After you have inserted all the subtotals that you want into your workbook, click Options on the Tools menu.
 * 8) On the Calculation tab, click Automatic.
 * 9) Click OK.

Additional query words: excel2003 excel2k3 excel11 xl2003 xl2k3 xl11 excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbformula kbexpertisebeginner kbprb KB839951

-

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

© Microsoft Corporation. All rights reserved.