Synchronize Pivot table page fileter

[[email protected]]

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

[Roger Govier]

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

[email protected] <[email protected]> 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

[theysaytrue]

Roger,
It's been 6 1/2 years since you've posted that and nobody has replied. However, I've looked everywhere and this is the best solution by far.
Thanks much. I'm glad the link is still working after all this time.