Excel Switch All Pivot Value Fields To Average or Max 2498

Microsoft Excel Tips and Tricks

Jeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?

Credit MrExcel.com

Please support our Sponsors here :