We have many spreadsheets created in excel 2003 that have charts that were created on separate sheets from the data. When we open them in Excel 2007 we cannot print. If you select print preview a blank page appears.
Also when the original data (on sheet1) is selected, and you go to the insert page to create a new chart, the charts are all greyed out.
converting the file to Excel 2007 does not resolve any of the issues.
The most important thing is to print the chart. We can copy the original data to a new workbook and recreate the charts, but thats very time consuming. Is there a faster resolution to this?