Thomas:
A while ago I had a couple of sheets to copy into another workbook with a
named range name that already existed (which I didnt realise). I remember
Excel popped up asking whether I would like to use the name already in the
destination sheet or to choose a new one (keeping the definition range in the
source sheet). If I remember this correctly, this might be the work around
you are looking for: you could try to copy the sheet to a new Book and copy
it back to the old one. Come to think of it a bit further, I believe it
requires that the sheet B to be copied back into sheet A should not contain
any links to sheet A, otherwise Excel is too smart and use these links (which
u don't want). Not sure whether it works in your case (your sheets may be
too complex) but possibly worth a try (Pls be careful to test it with an old
version of your sheet, just in case). Hope it solves yr problem.
Vbr,
Henk


"Thomas" wrote:

Thanks for your answer but I am not quite sure it does what I need. The
ultimate solution for me would probably be if I could define the series
in the chart in a way so that they refer to the locally defined name
for the worksheet in question. When I copy the original sheet with the
defined names the defined names will turn into locally defined names
only valid for the copied sheet. The problem is that the chart on the
new sheet does not refer to these defined ranges - it refers to the
original defined ranges on the original sheet. Do you know if there is
a way to specify the series so they always refer to the local names for
the corresponding sheet?

Great wbsite you have but I didn't really find a solution for this in
there either.

Thanks for any help you have!