Reply to thread

Message: [QUOTE="JP, post: 3162988"] Existing Excel 2003 macro creates a xls with pivot tables from a .csv file. This works in 2003. When macro run from Excel 2007 the pivot tables diplay an message "this pivot table report is not valid" when a 2003 user opens the xls file and clicks on any of the list boxes. The macro code has 'version10' for the pivot table coding and I have used the -4143 in code when saving file in an attempt to save in the 97-2003 format and have attempted to have a Save As dialog box appear so I can specify the .xls format when saving from 2007 but error still happens. I don't know if the file is being saved in the 97-2003 compatible mode or how to get the pivot table to work in 2003. [/QUOTE]