XL2000: Subtotals Are Not Recalculated When You Display Custom View (214351)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q214351

SYMPTOMS

The Subtotal function may not calculate values correctly when you display a custom view.

WORKAROUND

To work around this behavior, press CONTROL+ALT+F9.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about using custom views, click Microsoft Excel Help on the Help menu, type custom views in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about using subtotals, click Microsoft Excel Help on the Help menu, type insert subtotals into a list in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:MajorLast Reviewed:10/8/2003
Keywords:kbbug kbpending KB214351