Named data series won't dispay in Excel 2007

[hmm]

A file created with Excel 2000 contains a chart with a dynamic, named data
series. I emailed the workbook file to a colleague who uses Excel 2007.
When he opens the file, the data series simply doesn't display. When I
examine (in E-2007) the chart's source data, Excel tells me there is an error
in a formula. The three formulas are the names Header, xData, and yData
(preceded, of course, by the filename and "!"). When I enter one of these
names in the name box, it is recognized, as indicated by selection of its
cells. I was only able to get the chart to display the series by replacing
the x- and y-data names (xData and yData) with literal range references
(e.g., A1:A2000 and B1:B2000. Interestingly, the name "Header", referring to
a cell containing the chart series name, is resolved and displayed by the
chart.)

Can anyone tell me why named ranges for x- and y-data in charts are not
transferring from Excel 2000 to 2007, and how I can fix it? Thanks.

 

[ShaneDevenshire]

Hi,

I have created a 2000 Excel chart using dynamic range names and then opened
it in 2007 - there were no obvious problems. The dynamic ranges continue to
work.

One thing to keep in mind names some names which would have worked in 2000
will not work correctly in 2007 because they may be cell address or other
conflict.

 

[hmm]

Thanks Shane.

I checked the name syntax rules for Excel 2007, at:
http://office.microsoft.com/en-us/excel/HA101471201033.aspx#Syntax rules for names

They appear to be the same as for E-2000. Are there any undocumented rules
you know of?

 

[ShaneDevenshire]

I don't know if there is documentation in Help but try this in 2007


Define the name ABC1

That would work in 2000 but not in 2007 because that is now a cell address.

Same for A100000.

 

[Jon Peltier]

What do the series formulas look like in XL2000 and XL2007? There is a
problem with XL2007 in that sometimes the names in a series formula are
converted from Book1.xls!MyName to [0]!MyName. This is fixed in SP1.

- Jon