I've got a problem with a worksheet template I've created in Excel 2007. I use dynamic named ranges for the charts that are part of the worksheet. If I then copy the worksheet into a new sheet on the same file, I see that the named ranges copy across alright, but the name references in the charts are then lost. Is there a way to resolve this issue?

I did see that opening a copy of the same file and then copying the worksheet into a new tab from the other file did work, but this would not be my preference.

Regards,

Aaron