| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot tables in Excel 2003 and 2007 | Excel Discussion (Misc queries) | |||
| how do I refresh in excel 2007 a 2003 pivot table? | Excel Discussion (Misc queries) | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
| Excel 2007 pivot table formats that work with 2003 | Excel Discussion (Misc queries) | |||
| SOS!!! Excel 2007 - Pivot tables created in 2003 format | Excel Discussion (Misc queries) | |||
Threaded Mode
