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.