Synchronize Pivot table page fileter
 

Hi:

I have different tabs in a workbook that contains couple pivot table
sharing the same page filter. Is there a VBA function that I can
synchronize the selections by changing the filters on only one tab.

Thanks

Arale

Synchronize Pivot table page fileter
 

Hi Andrew

Debra Dalgleish has a download at her site which shows how to do this.
http://www.contextures.com/excelfiles.html

Scroll down to Pivot Tables and download
http://www.contextures.com/PivotMultiPagesChange.zip


--
Regards

Roger Govier

wrote
Hi:
I have different tabs in a workbook that contains couple pivot table
sharing the same page filter. Is there a VBA function that I can
synchronize the selections by changing the filters on only one tab.
Thanks
Arale