Hello,
Is there a way to ClearAllFilters on all Pivot Tables of a Workbook with a single command?
With the following code I reset loop through all PivotTables in the Workbook:
I would need to do a loop on all Pivot Tables with above code? or there is another fast way?Dim pvt As PivotTable Dim sh As Worksheet For Each sh In ThisWorkbook.Worksheets If sh.PivotTables.Count > 0 Then For Each pvt In sh.PivotTables pvt.ClearAllFilters Next pvt End If Next sh
Thanks!
Bookmarks