Problem with Insert "Name-Define"

[Michelle York]

I'm having a recurring problem with a couple of the Names that I'm trying to
define.

I have an excel Workbook that contains several different worksheets. I'm
trying to create a hyperlink from a cell on one worksheet to a cell on
another worksheet. I'm created and defined the names for many of the cells
already--"A", "B", etc--all the way to Z. These are the names because it's
a listing of books by their Alphabetical difficulty level. (Every book has
a level denoted by A-Z).

I've successfully defined names (and then easily hyperlinked to them) for
all but two letters. Consistently the "C" and "R" cells will not let me
define their names. It keeps saying "That name is not valid". I'm doing
absolutely nothing different for these two than I did any other letter. The
only way that I could get it to work is by defining them as "C_" and "R_".

Any idea why these two won't work the correct way?


Running Office 2004 (latest update with exception of the 5th.) Working on a
G4 Powerbook with OS 10.3.9.

 

[Ken Johnson]

Hi Michelle,

I'm guessing Excel has reserved C and R for Column and Row
respectively.

Ken Johnson

 

[Bob Greenblatt]

I'm having a recurring problem with a couple of the Names that I'm trying to
define.

I have an excel Workbook that contains several different worksheets. I'm
trying to create a hyperlink from a cell on one worksheet to a cell on
another worksheet. I'm created and defined the names for many of the cells
already--"A", "B", etc--all the way to Z. These are the names because it's
a listing of books by their Alphabetical difficulty level. (Every book has
a level denoted by A-Z).

I've successfully defined names (and then easily hyperlinked to them) for
all but two letters. Consistently the "C" and "R" cells will not let me
define their names. It keeps saying "That name is not valid". I'm doing
absolutely nothing different for these two than I did any other letter. The
only way that I could get it to work is by defining them as "C_" and "R_".

Any idea why these two won't work the correct way?


Running Office 2004 (latest update with exception of the 5th.) Working on a
G4 Powerbook with OS 10.3.9.

Ken provided the reason in his response. However, you are also "flirting"
with trouble in assigning names that may become ambiguous in certain
contexts. For example, the name "A" may be confused with column "A". You
should really rethink the names you are using.

 

[Michelle York]

The only thing that I could do to change it is to say "LevelA" instead of A.
I can't change the name itself, just the way I define it I guess.

Will this ever be an issue if the hyperlinks are the ONLY things I use
defined names for?