I have used Excel 97 to record macros that create PivotTables for years. With Excel 2000, however, I can record the macro but when I run it, I get a VB run-time 1004 error "Unable to get the PivotFields property of the PivotTable class" This is consistent. It never works. If I go back to Excel 97 and create the macro, I can run it in Excel 2000. Any ideas??
This message was edited by abe on 2002-03-20 12:33
This message was edited by abe on 2002-03-20 12:33