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