ClearAllFilters on all Pivot Tables of a Workbook

[trizzo]

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:

Please Login or Register  to view this content.

I would need to do a loop on all Pivot Tables with above code? or there is another fast way?

Thanks!

[ORoos]

Hi trizzo,

Try the below:

Please Login or Register  to view this content.