I hope you had a safe and happy New Year's Eve celebration, and are off to a good start in 2012. To see the steps for copying the code into your worksheet, and an explanation of how the code works, you can watch this short Excel video tutorial.Things got a bit rowdy at the Contextures office party, and I found these guys passed out on the floor, the next morning. The file will work in Excel 2007 or Excel 2010, if you enable macros. On the Sample Excel Files page, in the Pivot Tables section, look for PT0025 - Change All Page Fields with Multiple Selection Settings.
They get the same report filter settings that were in the pivot table that you changed. Despite the wild parties, I was able to get some work done over the holidays. There is a new sample file on the Contextures website, that changes all the pivot tables, when you change a report filter in one pivot table. Manual Update = False End If Next pt Next ws Next pf Main Application. Screen Updating = True End Sub To test the code, you can download the sample file from the Contextures website. Enable Multiple Page Items = b MI End Select End With b MI = False Set pf = Nothing pt.