J
JP
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.
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.