I use the following code to clear slicers from my PT:
How can I accomplish the same thing but for slicers that are part of a regular Excel Table?
VBA Code:
Sub clearSlicer()
Dim pt As PivotTable
Dim cache As Slicer
For Each pt In ActiveSheet.PivotTables
For Each cache In pt.Slicers
cache.SlicerCache.ClearAllFilters
Next cache
Next pt
End Sub
How can I accomplish the same thing but for slicers that are part of a regular Excel Table?