pivot table defaults

C

cturner08

When adding numeric fields to the Values section of a pivot table, is there a
way to have the Value Field Settings default to Average rather than Sum?
Seems like a lot of clicks are required to change every field individually.
 
J

Jacob Skaria

Sorry you cannot. If there are blank cells or cells with text the default
will be COUNT; or other wise it will be SUM.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Pivot Table question 1
function defaults change in Pivot Table..why? 2
Pivot table - value field settings - default? 2
Using text values in Pivot Tables 5
Average of % in pivot table 1
Pivot table question 2
Pivot Table not summing 2
Excel 2003: Pivot table value field settings 1

Top