This project has moved and is read-only. For the latest updates, please go here.

Chart - When copying worksheet the chart series doesn't update to reference new worksheet

Sep 27, 2012 at 6:56 PM

I am loading in a template that has a worksheet that I want to use as a template to create multiple sheets with data from a datatable. I copy this worksheet and then proceed to fill in the data. There are charts the display some of the data cell. However, the reference to these cell for the chart remain pointed back to the chart that was copied.

='GAUGE R&R'!$C$14:$L$14

'GAUGE R&R' is the name of the template worksheet. I would like to have it reference this worksheet

='DAT B101'!$C$14:$L$14

Is there a method to copy that will update references to curren(new) worksheet.

or

Is there a way to look for these references and change the name by searching through a worksheet

Jan 14, 2014 at 11:59 AM
Good morning,

I'm having the same issue. You solve this? Our anyone has solution for this?

Best Reggards,
NM