XL2007: Linked-labels reference is not copied with sheet

[Holger Gerths]

Dear group,

when I link a chart's text-labels with cells, the formula in the label
contains the sheet-name, e.g. =Mysheet!$A$1.
In 2003 or below, I could duplicate the sheet inside the workbook by copying
it.
Now in 2007, the cell-references in the linked labels remain on the old
sheet, they are not copied.
Is there any better way but copying the sheet into a second workbook,
renaming and then moving it back into first workbook?

Thanks,
Holger.

 

[Jon Peltier]

Yeah, they broke this in 2007. It sounds very familiar, I'm sure I've
reported it. I don't think there's a better way than what you describe.

- Jon