Why is R2K_Incept an invalid name for a named range?

[Jeremy Gollehon]

Repeat subject:
Why is R2K_Incept an invalid name for a named range?

Thanks,
-Jeremy

 

[Frank Kabel]

Hi
maybe you have used this name already? Otherwise this sholuld be
accepted

 

[Harlan Grove]

maybe you have used this name already? Otherwise this sholuld be
accepted

...

I've tried it in XL8/97. It's not accepted. No name beginning with R or C
immediately followed by a decimal numeral is accepted. I'd guess this is legacy
'functionality' due to the limitations of the formula parser in the original
Excel when using R1C1 addressing.

 

[Jeremy Gollehon]

...
..

I've tried it in XL8/97. It's not accepted. No name beginning with R
or C immediately followed by a decimal numeral is accepted. I'd guess
this is legacy 'functionality' due to the limitations of the formula
parser in the original Excel when using R1C1 addressing.

Thanks Harlan,
At least that makes some sense, however frustrating it is.
I'm using XL2003, so it hasn't been dealt with yet. Would you consider this
a bug that should be reported (not that it will matter)?

 

[Harlan Grove]

...
...

I'm using XL2003, so it hasn't been dealt with yet. Would you consider this
a bug that should be reported (not that it will matter)?

I'm certain Microsoft considers this a feature, and they won't change it because
doing so would impair backwards compatibility.

 

[support]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin

 

[Frank Kabel]

Hi Harlan
interesting. In Excel 2003 (German version) this name is accepted
without any problems

 

[Frank Kabel]

Hi
o.k. MS also decides to localize this 'feature'- So for me a name
starting with 'Z' or 'S' is not allowed.

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks Harlan,
At least that makes some sense, however frustrating it is.
I'm using XL2003, so it hasn't been dealt with yet. Would you
consider this a bug that should be reported (not that it will

matter)?