View Single Post
  #1   Report Post  
Pivot Novice
 
Posts: n/a
Default Pivot Table Field Settings

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.