Hello,
Given that I have multiple pivot table and each of the pivot table had it's slicers (no relationship). My question is, how can I clear the filters on the pivot tables that are not of the selected slicer?
For example:
I have 3 pivot tables and 3 slicers (again not related):
pvtBuilding - slicer_building
pvtEntities - slicer_entity
pvtCity - slicer_city
Assume that if user were to select an item(s) in the slicer_building, the other 2 pivot tables (pvtCity and pvtEntities) will need to ClearManualFilter, and remain the item(s) that user had selected on slicer_building.
I tried to code it, but it's giving me a loop.
Below is the simplified version of the code that I've made
Initially, when I don't have Application.EnableEvents, my macro would be able to kicks in, whenever I select a value from either of the slicers. But it'll just loop through the msgbox. But when I introduced the Application.EnableEvents, the macro didn't kick in.
Bookmarks