Aug 19, 2022 12:00 AM

Excel Switch All Pivot Value Fields To Average or Max 2498

External YouTube Channel

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 w...

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?

Table of Contents

(0:00) Welcome

(0:41) VBA

(1:55) Looping each field

(2:35) Copying for Sum, Max, Min

(3:10) Other calculations

(3:42) Easier way to run

(4:30) Running all 4 macros

(5:25) Upcoming Webinar