Resetting slicers

[luthien]

Hi,

I have a spreadsheet with around 20 slicers that one ca use to filter data on the graphs. Is there a fast way of resetting these with VBA?
I'm using the code below but it's slow with this number of slicers..

Please Login or Register  to view this content.

Cheers,
Monika

[Ron Coderre]

This is an untested suggestion...
Turn calculation to MANUAL before clearing the slicers...then reset it back to AUTOMATIC.

Please Login or Register  to view this content.

Does that help?