At the end of each month I compile a workbook which is made up of approx 20 spreadsheets. Some sheets are reports and some are graphs. The graphs are in excel which are emailed to me from other sources. Most typically the graphs are generated from data in another spreadsheet. The problem I am having is when I drag the spreadsheet with the graph into the final workbook I am compiling, the graph will typically loose its link to the datasource and then the graph no longer makes any sense. The only workaround I have come up with is to drag the spreadsheet with the data into the workbook as well and then hide the spreadsheet. This is very time consuming. Is there a way to turn a graph to "values" much in the same way as a spreadsheet?