Microsoft KB Archive/172789

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Article ID: 172789

Article Last Modified on 10/22/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q172789

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 the following:

  • You create multilevel subtotals by using the Subtotals command on the Data menu or run a Visual Basic for Applications macro to create subtotals with multilevel outlines. -and-


  • You clear the Summary Below Data check box in the Subtotals 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 this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about creating multilevel subtotals, click the Index tab in Help, type the following text

subtotals, multiple-level


and then double-click the selected text to go to the "Insert subtotal values into a list" topic.


Additional query words: nest nested layered multiple order stagger

Keywords: kbbug KB172789