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 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. How do I remedy so the Excel 2003 user can open a file that is usable?
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 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. How do I remedy so the Excel 2003 user can open a file that is usable?
P.S.: to check this you will probably need access to Excel 2007 and Excel 2003.