Automatic Filter all Slicer's at once

[Kamal GKJ]

Hi,

As I have used over 7 Slicers and at a STRETCH I NEED TO REMOVE ALL FILTER. Can anyone help me with the data..

 

[Kamal GKJ]

Hi Friends,

Do any one have an idea behind this..

 

[Saneesh]

Hi,

As I have used over 7 Slicers and at a STRETCH I NEED TO REMOVE ALL FILTER. Can anyone help me with the data..

Try this:

Dim cache As SlicerCache 
 
For Each cache In ActiveWorkbook.SlicerCaches 
 cache.ClearManualFilter 
Next cache

 

[Kamal GKJ]

Thank You so it worked well..

Kamal