Macro in 2003 vs 2007

M

MichaelR

Hi,

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

Sheets(2).PivotTables("PivotTable1").ClearAllFilters.

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.
 
M

MichaelR

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table macro with a filtering variable 3
Macro for Pivot in MS Excel 2003 vs 2007 1
Can't change pivotfilter value1 parameter in code 0
Data Fields in Pivot Table 2
Help with function VBA existing code. 1
VBA Pivot Table Error 1
Programming a macro in Excel Office 2007 to create Pivot Table 1
Macro to update pivot table data range 3

Top