Macro to clear data filters and pivot table filters on all worksheets in workbook

[jeff_cp]

I've got a spreadsheet that consists of dozens of worksheets that compiles data for a summary worksheet. When a user filters one of the data tables or pivot tables, it changes the totals on the summary worksheet. I'd like to put a Clear All Filters button on the summary worksheet that will remove all filters on all worksheets. Is this possible without clearing them individually?

 

[CeceR]

Try looping through the sheets with something like this. This should clear any filters on all sheets. I've not tested it, but I can mock something up if you run into problems.

Sub ClearFilters*(
For j = 1 To Sheets.Count
    
    Sheets(j).Activate
    Sheets(j).AutoFilter.ShowAllData

Next j
End Sub