[Matthew Wieder]

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!

[Lynn Schauer]

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!