Hi,

I have the following macro that clears all filters in a pivot table of mine
in 2007:

Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs.

When I try to run the macro in 2003 I get an error message that says:
"Object doesn't support the property or method."

Any ideas for how I can clear all filters in my pivot table in excel 2003
using a macro.

Thanks.

Turn it on or off. That's all
Selection.AutoFilter
Skinman

"MichaelR" wrote in message
...
Hi,

I have the following macro that clears all filters in a pivot table of
mine
in 2007:

Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs.

When I try to run the macro in 2003 I get an error message that says:
"Object doesn't support the property or method."

Any ideas for how I can clear all filters in my pivot table in excel 2003
using a macro.

Thanks.

I believe that works for a table with filters but unfortunately not for a
pivot table.

"Skinman" wrote:

Turn it on or off. That's all
Selection.AutoFilter
Skinman

"MichaelR" wrote in message
...
Hi,

I have the following macro that clears all filters in a pivot table of
mine
in 2007:

Sheets(2).PivotTables("PivotTable1").ClearAllFilte rs.

When I try to run the macro in 2003 I get an error message that says:
"Object doesn't support the property or method."

Any ideas for how I can clear all filters in my pivot table in excel 2003
using a macro.

Thanks.