Changing summary for multiple value fields in a pivot table - Excel 2007

[scriwa]

Hi,

I'm using Excel 2007 and have a pivot table with multiple values and need to average all the data rather than sum. There are a lot of columns of data in my original data sheet so it will take quite a long time to manually change the "Value Field Settings".

Is there a way to automatically change all the values at the same time? I know in Excel 2003 there is an add-in (PivotPower) that automatically does this, but does this add-in work in 2007 (I can't get it to do so)?

Any help would be much appreciated!

Thanks!

 

[scriwa]

Sorry, please ignore, I entered in the wrong forum.