Update report filter across multiple pivot tables

[mduff]

Hi,

I have a worksheet with 7 pivot tables in one worksheet what I am looking to do is when one of the pivot tables report filter is updated it will update on all of them so I have the filter to be on work weeks if I change one of them to 4 I would like all of them to be updated to 4 same if I select multiple items

Please note I am using excel 2007 if this will make a difference.

Please let me know if you have any questions and thanks in advance

[mbarron]

Can you post an example of your set up? Sterilize the data - ie removed any "not for everyone's eyes" information.

[mduff]

Can you post an example of your set up? Sterilize the data - ie removed any "not for everyone's eyes" information.

Sorry Not sure how to post a sheet I can email you a Sterilize vestion or If you let me know how I can post it

thanks

[mbarron]

Click the [Go Advanced] button in the Quick Reply area below the thread.
Click the [Manage Attachments] in the Additional Options area.
[Browse...] for your file then [Upload]
[Submit Reply]

[mduff]

the sheet I am looking at is ActualVsFC

thanks for the help

[mbarron]

I added code to the ActualVsFC sheet. To execute it, just change the filter option for any of the pivot tables.

[mduff]

thanks that did the trick

you rock