Programatically Breaking Links of Copied Chart Sheet
I am automating a porcess which updates some data in a source workbook
that has a chart linked to it. It then copies the newly calculated chart sheet to a new workbook, and repeats the process of changing the data in the source workbook, recalcing and again copyign the chart sheet. The problem is that all the charts maintain links to the original source workbook and as a result all end up looking the same as the most recent chart. I use sheet copy to copy the sheets and I must continue to do this for the benefits it allows over cells.copy. Is there some method I can call on the target workbook that would break the links to the source workbook? thanks! |
Programatically Breaking Links of Copied Chart Sheet
one way would be to also copy the data sheet to the new workbook along with
the chart sheet. You could then hide the data sheet in the new workbook if you dont want to see it there. for other options see: http://www.geocities.com/jonpeltier/...ChartData.html Lynn S "Matthew Wieder" wrote in message ... I am automating a porcess which updates some data in a source workbook that has a chart linked to it. It then copies the newly calculated chart sheet to a new workbook, and repeats the process of changing the data in the source workbook, recalcing and again copyign the chart sheet. The problem is that all the charts maintain links to the original source workbook and as a result all end up looking the same as the most recent chart. I use sheet copy to copy the sheets and I must continue to do this for the benefits it allows over cells.copy. Is there some method I can call on the target workbook that would break the links to the source workbook? thanks! |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com