Hello All

I have a file utilizing a Power Pivot database.
The file has about a dozen pivot tables connected to 15 different slicers.
If I make a change to one of the slicers, it can take about 8 seconds to change all of the outputs on all of the pivot tables.

I am looking for a macro that will stop pivot tables from automatically updating when a slicer is manipulated.
This way, I'll be able to change 4 or 5 slicers without having to wait for all of the pivot tables to update each time. I would then need an "Execute" macro to update the pivot tables once all of the slicers have been set to what I want.

Any assistance, or additional info, would be greatly appreciated.

Thanks in advance!