Dear All,

I have a macro that loops through all values of a slicer and then performs an action (saving the sheet as another file).
The problem is that it takes ages (hours) to run even a single loop.
I suspect this is because each time an item is unselected in the slicer, Excel performs the slicer action.

Is there a way to avoid this?
Conceptually, could I run the action "for each slicer item, check if x, if yes select, if no unselect", and then redo the pivot table only at the end of that series of checks (and then export the sheet)?

Here is my code:

Please Login or Register  to view this content.
Any help is appreciated. Thanks!