Microsoft KB Archive/212099

= XL2000: Missing Totals When Using Multilevel Subtotals =

Article ID: 212099

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212099





SYMPTOMS
When you create multilevel subtotals for data, the totals appear in the incorrect order (staggered incorrectly) and may exclude grand totals for some functions.



CAUSE
This problem occurs when you do both of the following:
 * You create multilevel subtotals by using the Subtotals command on the Data menu, or you run a Visual Basic for Applications macro to create subtotals with multilevel outlines.

-and-
 * You clear the Summary below data check box in the Subtotal dialog box.



WORKAROUND
To work around this problem, click to select the Summary below data check box in the Subtotal dialog box.

If you are using a Visual Basic macro to create your subtotals, set the optional SummaryBelowData argument to True or use the xlSummaryBelow constant. The following macro gives an example of this argument: Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=xlSummaryBelow



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

