I am building a dashboard in which 3 sliders control 10 pivot tables on a second data sheet. I also have a map drawing on the pivot data. This is populated by a macro that needs to be triggered each time a selection is made on the slicer. After reading through old questions and other forums, I've used the following code, placed in the sheet that contains the pivots.
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Application.EnableEvents = False
Call UpdateMaps
Application.EnableEvents = True
End Sub
With this, changes to the sliders do activate the macro to update the map, but despite the EnableEvents toggling, it triggers 10 times; once for each of the pivot tables, and so is very slow. Am I missing something? Is there a way to have only one triggering of the macro, which would take place after all of the pivot tables have finished updating from the Slicer selections?