Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XL2007: Linked-labels reference is not copied with sheet
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XL2007: Linked-labels reference is not copied with sheet
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Holger Gerths" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Odd Excel 2007 behavior: copied chart linked to source sheet | Charts and Charting in Excel | |||
How do I get a worksheet reference to increment when copied | Excel Worksheet Functions | |||
XL2007 and array of sheet names? | Excel Discussion (Misc queries) | |||
empty copied/linked cells contain 0 | Links and Linking in Excel | |||
Can I control linked cell property value in a copied ActiveX contr | Excel Discussion (Misc queries) |