Changing default for field settings in pivot tables

Every time I create a pivot table, the fields are automatically set to Sum. Is there a way to change the default so I can get them to automatically be set to Average as I build the table. I have a ton of fields to add and do not want to have to change the field settings on every one.

Thanks RomperStomper,

I was afraid that was going to be the answer. By the way, do you have similar code that sets the defaults to not display sub-totals?

Thanks Again,
Jim

Wow, thanks. Should have asked this question a long time ago....

Really appreciate your help!

Jim