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 ]