I can copy a worksheet with embedded charts to new workbook in Excel 2003 and break links and chart data is retained as values only. (Source data remains in original workbook). Same process in Excel 2007 causes chart data to be replaced by #REF. Any ideas, please?