Excel 2003 may appear to endlessly loop calculating cells when you insert subtotals in an Excel 2003 workbook (839951)


The information in this article applies to:

  • Microsoft Office Excel 2003

SYMPTOMS

When you insert a subtotal in a Microsoft Office Excel 2003 workbook, Excel 2003 may appear to endlessly loop calculating cells.

Note To insert a subtotal in an Excel 2003 workgroup, on the Data menu, click Subtotals.

CAUSE

This behavior occurs because Excel 2003 cycles through the calculation process one time for each subtotal formula that is inserted in a workbook.

Note This behavior is a design change from earlier versions of Microsoft Excel.

WORKAROUND

To work around this behavior, follow these steps:
  1. On the Tools menu, click Options.
  2. On the Calculation tab, click Manual.
  3. Click OK to close the Options dialog box.
  4. Select the cell where you want your 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 all the subtotals that you want inserted in your workbook, click Options on the Tools menu.
  8. On the Calculation tab, click Automatic.
  9. Click OK to close the Options dialog box.
Modification Type:MajorLast Reviewed:4/19/2004
Keywords:kbprb KB839951 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.