XL2007: Linked-labels reference is not copied with sheet

  • Thread starter Thread starter Holger Gerths
  • Start date Start date
H

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.
 
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
 
Back
Top