Pivot table default settings ?

[twaccess]

Pivot table default settings ?

I use Pivot tables a lot, and find that I never use the Automati
setting for totalling columns and it’s a repetitive task to reset eac
of these to “None” every time I create a pivot table.

Is there any way I can set this to default to None for every pivo
table I create ?

Terr

 

[Debra Dalgleish]

I don't know of a way to change the default setting for subtotals. After
you've created the pivot table, you could use a macro to turn off the
subtotals. For example:

Sub NoRowAutomaticSubtotals()
'turns off Automatic subtotals in pivot table
Dim pt As PivotTable
Dim pf As PivotField
For Each pt In ActiveSheet.PivotTables
For Each pf In pt.RowFields
pf.Subtotals(1) = False
Next pf
Next pt
End Sub