Hey all,

I am trying to create a macro that will change all pivot fields with a certain name to the value I have the master pivot changed to. For example, I have 5 pivot tables, which each contain the field "Fruit". I want to change the 1st pivot table to "Apples", "Oranges", and "Pears" as active values, and have the other pivot tables also have these values. I'm not sure how to write in VBA in order to do this. Any help would be appreciated. Thanks!