(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