Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default 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








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
Linking to a pivot table from a formatted invoice Spaceman Spiff Links and Linking in Excel 1 January 1st 06 10:02 PM
pivot table rmsterling Excel Discussion (Misc queries) 5 November 14th 05 04:40 PM
Pivot Table Cycling Through Page Fields Automatically nrehman Excel Discussion (Misc queries) 14 October 13th 05 07:32 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"