Pivot Table Defaults Turn Off Subtotal

  • Thread starter Thread starter Commish
  • Start date Start date
C

Commish

Is there a way to change the default behavior of Pivot Tables?

Specifically, can I change the default behavior for a Field to NOT
show the subtotals?

I know how to turn it off easy enough - it's just frustrating doing it
over and over.

Thoughts?
 
I have not answer, just want to agree that this is a frustrating issue.

Ie, everytime I build a Pivot Table, I have to go through the process of
manually turning off the subtotals.

Another issue I run into is that generally my pivot tables need to have the
'Field Settings' / 'Layout & Print' changed via a manual process to check the
option box 'Show Item labels in tabular form'.

Both of these issues are so frustrating that I often find other ways to
summarize my data; ie, use Access or Microsoft Query.
 
In Excel 2007 you can turn off all subtotals for the active pivot table,
and prevent new subtotals from appearing:
Select a cell in the pivot table
On the Ribbon, click the Design tab
In the Layout group, click Subtotals, and click Do Not Show Subtotals.

However, there's no setting you can change to make this the default
behaviour for all pivot tables.

In earlier versions of Excel, you have to turn off the subtotal for each
field individually, either manually or programmatically. There's a
subtotals command in my pivot table add-in:

http://www.contextures.com/xlPivotAddIn02.html
 
Back
Top