I have two worksheets, one with data and one with charts that plots the data,
i.e. Charts and Data.
I want to do a relative copy of both sheets so that all the links in Charts
(2) update to the new Data (2).
This is what I have do,
Select both Sheets using <cntrl, right click
Right click on tab area, select 'move copy'
Check copy, create copy
This creates new sheets with xxxxx (2) as the name.
The cell formulas all update to the new Data (2) worksheet as expected.
But the charts in Charts (2) still reference the original Data worksheet.

Is there a way to have the charts update the links to the newly created Data
(2) sheet like the cells do?

Thanks,
DA