Using Range Names in Charts
 

I just converted from Excel 2003 to 2007.
Whwn I try to use Range Names in charts I get an error "Formula contains
invalid references"
Please Help
--
Eli Kedar
Israel

Using Range Names in Charts
 

If the name begins with "chart", you may have trouble implementing it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Eli Kedar" wrote in message
...
I just converted from Excel 2003 to 2007.
Whwn I try to use Range Names in charts I get an error "Formula contains
invalid references"
Please Help
--
Eli Kedar
Israel

Using Range Names in Charts
 

Hi,

Jon has given you one reason, here is another

If the chart is bound to a table (list) range:

"you may receive the following error message:
A formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference."

See the following for the complete explanation, but no solution:
http://support.microsoft.com/kb/931389/en-us

--
Thanks,
Shane Devenshire


"Eli Kedar" wrote:

I just converted from Excel 2003 to 2007.
Whwn I try to use Range Names in charts I get an error "Formula contains
invalid references"
Please Help
--
Eli Kedar
Israel

Using Range Names in Charts
 

Thanks Shane, that was my problem

Eli
--
Eli Kedar
Israel


"ShaneDevenshire" wrote:

Hi,

Jon has given you one reason, here is another

If the chart is bound to a table (list) range:

"you may receive the following error message:
A formula in this worksheet contains one or more invalid references. Verify
that your formulas contain a valid path, workbook, range name, and cell
reference."

See the following for the complete explanation, but no solution:
http://support.microsoft.com/kb/931389/en-us

--
Thanks,
Shane Devenshire


"Eli Kedar" wrote:

I just converted from Excel 2003 to 2007.
Whwn I try to use Range Names in charts I get an error "Formula contains
invalid references"
Please Help
--
Eli Kedar
Israel