I have a master workbook which does a series of calculations, then produces an embedded chart on a worksheet
I then copy this worksheet to a new workbook using Edit / MoveCopy sheet. The chart appears OK and correct.
When I run another study in my master workbook, and copy the latest chart to a new worksheet in the same new workbook, this apprears OK, but the original chart in the new workbook changes , to show the latest master chart - ie all the charts copied to the new workbook show the same, which is the latest chart on the mater workbook.
Can anyone please advise how I can break the links after copying the chart from the master?
I then copy this worksheet to a new workbook using Edit / MoveCopy sheet. The chart appears OK and correct.
When I run another study in my master workbook, and copy the latest chart to a new worksheet in the same new workbook, this apprears OK, but the original chart in the new workbook changes , to show the latest master chart - ie all the charts copied to the new workbook show the same, which is the latest chart on the mater workbook.
Can anyone please advise how I can break the links after copying the chart from the master?