Changing the default settings on excel for pivot tables

[jasonpfuhrman]

Is there a way to change the default setting for the value field settings for a pivot table so that when you add new items, they are calculated automatically as average instead of sum or count?

 

[Greg Truby]

Hmmm, not that I've ever seen. But if you're running 2007 or 2010, there are a couple of options that easier than drilling down to the Field Settings.... You can just right-click one of the cells in the data area and change the Summarize By setting in the popup.

There's also a Summarize Values By button on the [PivotTable Toosl] Options tab in the ribbon.

 

[Greg Truby]

[Crosspost]

Jason - if you are going to Cross Post, then please include links to every site where you have posted this question. Furthermore, should you ever get an answer to this, please go back to every site where you posted the question and post a link to the site containing the answer, or copy and paste the answer all around [your choice].

Also - when they catch you cross posting, many forum's moderators [including this one's], will post a link to Ken Pulz' comments on the topic of crossposting.