I got 4 slicers - "Class", "Course", "Presenter" and "Topic" to update an identical pivot table. However, I just want the specific slicer, say the bottom layer of the 4 slicers - "Topic" to triger the Workbook_SheetTableUpdate event other than the rest ones otherwise. How can I modify the VBA script?



Alternatively, if I use Worksheet_PivotTableUpdate event
other than above mentioned Workbook_SheetTableUpdate event , how to change the code?

and the last but not least, it must be a way to run the VBA behind the scenes making it invisible while the cursor moves around the worksheet, right? How to make it happen?

Attached Files

test.xlsm (202.5 KB, 10 views)