I have a macro that copies tabs from one workbook to a new workbook. The graphs based on pivot tables lose their link to the data source (pivot table) and I have to manually reset. Does anyone know of a way to preserve the graph data source?