How to reset all the slicers in a powerpivot at one go.

[Krishh]

Hi

I have 4 slicers (lets say) and i want to clear filters from all 4 slicers with one click or shortcut. Like we use alt+a+c in a normal sheet to clear filter from all columns.

Same way can we have it done in powerpivot slicers.

I tried this but it didn't happen..


"Dim slcr As SlicerCache

For Each slcr In ActiveWorkbook.SlicerCaches

slcr.ClearManualFilter
Next slcr"

 

[Luke M]

This works fine on my workbook.

Sub ClearSlicers()
Dim Slcr As SlicerCache
For Each Slcr In ActiveWorkbook.SlicerCaches
    Slcr.ClearManualFilter
Next
End Sub

What happens when you run it in yours?

 

[Krishh]

Thank you..it worked.