Can I change the default summary in an Excel Pivot table?

[ericb123]

Using Excel 2003 & 2007, when I create a pivot table, Excel defaults the summary fields to always be a sum, but I rarely if ever use sum.

Is there a setting somewhere that I can change this to default to Average instead of Sum so that I don't have to keep changing it each time?

Any help is appreciated, thanks!

 

[xlbo]

sorry but I don;t think so

Sum is the default for numeric fields. Count is the default for text fields

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Gavona]

Welcome to Tek-Tips!
I have a few Visual Basic Routines (macros) to do things like this for me (change to sum and display no decimal points plus thousands separators). If you are interested then start the recorder:
Tools, macro, record New Macro
Record changing the pivot table
have a look at the code produced, try to modify it to work on any pivot table

Post back in Forum707 for help in making the recorded macro into a more general purpose routine. You will get loads of help if you are clear what you are trying to achieve and it is clear that you have tried yourself and want to learn (rather than want someone to solve it for you0.

Gavin