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!