View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MichaelR MichaelR is offline
external usenet poster
 
Posts: 38
Default Macro for Pivot in MS Excel 2003 vs 2007

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.