Pivot Table default Value Field Settings

  • Thread starter Thread starter Max Scott
  • Start date Start date
M

Max Scott

Hi

I use pivot tables a lot and the vast majoirty of the time I use it to sum
data. Excel defaults the Value Field Setting to Count so I have to change it
every time. Is there any way I can change the default to Sum?

Thanks
 
If all the data in the field is numeric, then you'll see Sum.

If any of the data in the field is text (or empty!), then you'll see Count.

I don't think you can change this behavior.

But you can use Debra Dalgleish's pivottable addin to lots of stuff:
http://contextures.com/xlPivotAddIn.html
 
Back
Top