Pivot Table Field Settings

[Cindy E]

Is there a way to change the default in the field settings or change multiple
lines at once from "count" to "sum"?

Thanks,

Cindy

 

[Jim Thomlinson]

Nope...

 

[Roger Govier]

Hi Cindy

Jim is quite right, there is no inbuilt feature to do this.
But, Debra Dalgleish has a nice add-in on her site which allows you to do
many things with the Pivot Table, including changing all data fields to the
selected summary function.

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