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
Hi Andrew
Debra Dalgleish has a download at her site which shows how to do this.
www.contextures.com/excelfiles.html
Scroll down to Pivot Tables and download
www.contextures.com/PivotMultiPagesChange.zip--
Regards
Roger Govier
gt; wrote
gt; Hi:
gt; I have different tabs in a workbook that contains couple pivot table
gt; sharing the same page filter. Is there a VBA function that I can
gt; synchronize the selections by changing the filters on only one tab.
gt; Thanks
gt; Arale
- Oct 22 Sun 2006 20:10
Synchronize Pivot table page fileter
close
全站熱搜
留言列表
發表留言