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: 3
Default How do I get Pivot filter change event to fire?

I need to match the filters (if that's what the drop-down
boxes on the pivot table are called) on a number of pivot
tables. That is, if the filter on one is changed (for
simplicity, let's assume there's a master pivot), then the
other three pivot tables should also match that filter.
In more concrete terms, if a user selects "February" on
the drop-down in the master pivot, then the slave pivots
should all display the data for February also.

I'm having a heck of a time getting Sheet_PivotTableUpdate
to fire, and I'm not even sure that's the right event to
be looking to trap. The documentation "assumes" that a
Sheet object has been defined in a class module, and I
can't find documentation on how to do that (sometimes
search is wonderful, other times it gives me nothing
useful).

I have reasonable experience with VBA after command
clicks, but really am a newbie when it comes to
this "event handling." Thanks for any help (in
advance)... I'm going on vacation shortly, so if I don't
respond quickly, it's not for lack of appreciation, it
just means power got restored in NY and my flight took off.

Claude
 
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
Fire Macro from Cell Change Slashman Excel Worksheet Functions 7 October 17th 06 04:08 AM
Event doesn't fire Frank Xia Excel Discussion (Misc queries) 6 February 11th 06 12:54 AM
Adv. Filter & Worksheet Change Event Russell[_3_] Excel Programming 0 July 17th 03 01:51 AM


All times are GMT +1. The time now is 04:07 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"