Pivot Table Field Settings

[Pivot Novice]

I am using Excel 2003. When I pivot data, I frequently do not want the
automatic sub-total for the fields.

Can I change the default sub-total field setting to "None", instead of
"Automatic"?

It's kind of a pain to constantly change the field setting everytime I move
data around.

 

[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 them off.
There's code to do that in my pivot table add-in, that you can download
here:

http://www.contextures.com/xlPivotAddIn.html

 

[Pivot Novice]

That's AWESOME!
Thanks a lot.

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 them off.
There's code to do that in my pivot table add-in, that you can download
here:

http://www.contextures.com/xlPivotAddIn.html

 

[Debra Dalgleish]

You're welcome! I hope it helps.

That's AWESOME!
Thanks a lot.

:

 

[Ngan]

Wow, that's great! Thanks for your hard work and sharing it with us!!!!!

 

[Debra Dalgleish]

You're welcome!

Wow, that's great! Thanks for your hard work and sharing it with us!!!!!

: