The workbook I've includes several sheets, and each sheet includes a Pivot Table.
I've gave a name for each Pivot Table in each sheet.
Now I am making a macro to clear filter and refresh each pivot table in each sheet but I want to do it at once.
Can I make the macro without using "ActiveSheet."
and only add the Pivot Table name ?
ActiveSheet.PivotTables("PivotTableName").ClearAllFilters
The result I am looking for is to refresh each sheet and clear filter for each sheet.
So I want to determine the pivot table name in each sheet and then choose to clear filter and refresh at once.
Bookmarks