Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking Links - BUT WHERE ARE THEY??? | Excel Discussion (Misc queries) | |||
Odd Excel 2007 behavior: copied chart linked to source sheet | Charts and Charting in Excel | |||
Graph links to copied sheet | Charts and Charting in Excel | |||
breaking links | Excel Discussion (Misc queries) | |||
Breaking Links | Excel Discussion (Misc queries) |