Chart values do not update links to new worksheet

D

DA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top