Hello Forum,

Thanks in advance for any ideas/help.

I have 3 slicers (say named One, Two, and Three) on Sheet1 that are all connected to a series of pivot tables (on Sheet2) that run off the same data set. I'm looking for code to "turn off" (disable, set to manual, ??) the refresh action slicers initiate when a selection (or deselection) is made. The use case is that a user of these slicers would make the selections they desire without any refresh of the pivot tables. When ready for the refresh press a command button (Button1) and the results section of Sheet1 then displays the refreshed data.

Hope that makes sense and thanks so much for any help!

Best regards,
Chris