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