Excel 2007 : Master Filter to change filter on multiple pivot tables?

[jonswift]

(In Excel 2007) I have a report that runs on several pivot tables from a few different queries on a seperate tab. It rolls up to a nice looking summary which consists of the report that end users see.

All the pivot tables have the same attribute for their filter. Is there a way to change the filter to a different value for all pivot tables at once? Right now I have to change them one by one and obvioulsy can't expect a user to do that.

Thanks,
Jon Swift

[jonswift]

Any ideas?

[DonkeyOte]

Something along the lines of the below perhaps ?

Please Login or Register  to view this content.

where MASTER!A1 holds the value to be applied to the Page filter.

[jonswift]

Something along the lines of the below perhaps ?

Please Login or Register  to view this content.

where MASTER!A1 holds the value to be applied to the Page filter.

I played with this a little, seems like I can work with this.
Thanks.