Pivot Table Help

[Guest]

How do I change my default setting from "count" to "sum" so when I create new
pivot tables and won't have to keep changing each individual field??

 

[Debra Dalgleish]

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.

 

[Dave Peterson]

I don't think you can.

If there are any non-numeric entries in that field, excel will use Count. This
includes text and empty cells.

In fact, Debra Dalgleish shares a pivottable addin that you may want to try:
http://contextures.com/xlPivotAddIn.html

And this is from the instructions page:
http://contextures.com/xlPivotAddIn02.html#DataFields