In our environment we have Office 2007 with the compatibility pack (added when we were still in Office 2003) and have chosen to have the default save as 97-2003.
I have a user who created an Excel 2007 spreadsheet with a normal embedded chart in a sheet and saves using the default (Excel 97-2003). When he sends it to people on Office 2003, the chart in Excel 2003 comes over as a picture and if that user tries to import the file to extract data it looks like HTML or XML - not usuable. Went to run Compatibility checker in Excel 2007 and it was grayed-out. Seems like a compatibility issue. How do I remedy?
P.S.: to check this you will probably need access to Excel 2007 and Excel 2003
I have a user who created an Excel 2007 spreadsheet with a normal embedded chart in a sheet and saves using the default (Excel 97-2003). When he sends it to people on Office 2003, the chart in Excel 2003 comes over as a picture and if that user tries to import the file to extract data it looks like HTML or XML - not usuable. Went to run Compatibility checker in Excel 2007 and it was grayed-out. Seems like a compatibility issue. How do I remedy?
P.S.: to check this you will probably need access to Excel 2007 and Excel 2003