I am constantly making workbooks with 12 spredsheets (one for each month of
the year). In these spredsheets I have embedded charts.

When I have done the setup for the first month I make 11 copies of the
January sheet and do search replace in these ones to make them correct.

Problem is - I haven't found any way to avoid having to change all
datasources of the charts manually. They are all linked to the original
spredsheet and not their new "mother" - the copy.

I am very grateful for help in this one.

Best,

Helge

Hi Helge,

Right-click the sheet tab, select move or copy, check the create a copy box.

Ed Ferrero

"Helge" wrote in message
...
I am constantly making workbooks with 12 spredsheets (one for each month of
the year). In these spredsheets I have embedded charts.

When I have done the setup for the first month I make 11 copies of the
January sheet and do search replace in these ones to make them correct.

Problem is - I haven't found any way to avoid having to change all
datasources of the charts manually. They are all linked to the original
spredsheet and not their new "mother" - the copy.

I am very grateful for help in this one.

Best,

Helge

Ed,

Thank you for your quick response!

That's exactly what I am doing. Still the references in the data source of
the copied sheet's charts are pointing to the original sheet and not the copy.

Can there be any settings somewhere to fix this?

Helge

"Ed Ferrero" wrote:

Hi Helge,

Right-click the sheet tab, select move or copy, check the create a copy box.

Ed Ferrero

"Helge" wrote in message
...
I am constantly making workbooks with 12 spredsheets (one for each month of
the year). In these spredsheets I have embedded charts.

When I have done the setup for the first month I make 11 copies of the
January sheet and do search replace in these ones to make them correct.

Problem is - I haven't found any way to avoid having to change all
datasources of the charts manually. They are all linked to the original
spredsheet and not their new "mother" - the copy.

I am very grateful for help in this one.

Best,

Helge