Turning off pivot table subtotals in Excel 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to turn off the automatic piviot table subtotals in Excel
2002? I can't find it as an option under "field settings >subtotals > none"
as it is in 2003 and later.
 
Hello,

In Excel 2002 you can try this....Click a cell in the list that contains a
subtotal.
On the Data tab, in the Outline group, click Subtotal.
The Subtotal dialog box is displayed.

Click Remove All.


When you remove subtotals, Microsoft Office Excel also removes the outline
(outline: Worksheet data in which rows or columns of detail data are grouped
so that you can create summary reports. The outline can summarize either an
entire worksheet or a selected portion of it.) and any page breaks that you
inserted into the list along with the subtotals.
 
Back
Top