LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default change pivot filter through code

Hi,

I've posted before on this, but had no luck - annoying as I know it is
possible since I've done it myself in the past (but lost the file!).

I have 2 pivot tables on a sheet which both have the same report filters.

When I change the filter selection on pivot table 1, I want (assumingly
through code) for pivot table 2 to automatically apply the same report filter.

Hope u can help,

Thanks,

Basil
 
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
Single Filter to change all Pivot Tables in a Workbook Kathy L.[_2_] Excel Discussion (Misc queries) 8 March 15th 11 08:52 AM
Several Pivot Tables: Change one filter and adapt it for the other Aloha08 Excel Discussion (Misc queries) 2 June 12th 09 02:49 AM
Changing pivot filter causes chart type to change! Why? DenizDuelec Excel Programming 2 August 28th 08 10:24 AM
Color Code Filter indicators - Change from Blue to Red Martinson44 Excel Worksheet Functions 0 November 10th 04 04:25 AM
How do I get Pivot filter change event to fire? Claude Excel Programming 4 August 15th 03 10:24 PM


All times are GMT +1. The time now is 05:40 PM.

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

About Us

"It's about Microsoft Excel"