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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks