You can use the ClearAllFilters method:

ActiveSheet.PivotTables(1).ClearAllFilters

MichaelR wrote:
Set the values on all of the fields to "All." Sorry for not being clear.

"Jim Thomlinson" wrote:


Define Clear all filters. Do you want to remove them or do you want to set
the values to All...
--
HTH...

Jim Thomlinson


"MichaelR" wrote:


Is is possible to write a macro that will clear all of the filters in a pivot
table/chart (i.e. the report filter, column labels and row labels filters)
regardless of which pivot fields are being used in the report?

Thanks,
Michael



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com