Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Single Filter to change all Pivot Tables in a Workbook | Excel Discussion (Misc queries) | |||
Several Pivot Tables: Change one filter and adapt it for the other | Excel Discussion (Misc queries) | |||
Fire Macro from Cell Change | Excel Worksheet Functions | |||
Event doesn't fire | Excel Discussion (Misc queries) | |||
Adv. Filter & Worksheet Change Event | Excel Programming |