ID: Q119133
The information in this article applies to:
In the versions of Microsoft Excel listed above, if the link from a chart sheet to data on a worksheet goes through more than one layer of defined names, the name in the chart series link formula is not copied correctly when you copy the chart sheet: the new chart will contain an invalid link to the original chart tab instead of a link to the workbook.
For example, if you create a defined name on a worksheet called "Name1," and you then create another defined name that refers to "Name1" and call it "Name2," and you then create a chart sheet using "Name2" as the data range, (you can do this by editing the Names and Values tab of a chart sheet), when you make a copy of this chart sheet in the same book, the new chart will appear to be correct, but the chart series information will be incorrect.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.
Additional query words: 5.00 5.00a 5.00c 7.00 7.00a XL7 XL5
Version : WINDOWS:5.0,5.0c,7.0,7.0a; MACINTOSH:5.0,5.0a
Platform : MACINTOSH WINDOWSLast Reviewed: February 4, 1998