illegal name? [noobie, please be gentle]

M

mr_unreliable

re: xl2k

I am attempting to name a column as "fy2007"

xl refuses to accept this. Why?

Note that "fy2007" appears to satisfy all the naming
guidelines, as listed in the help file.

Also note, "fy_2007" is acceptable.

cheers, jw
 
D

Dave Peterson

FY2007 looks like a cell in column FY in row 2007.

You could name it
FY_2007
or
_FY2007

Or most anything that doesn't look like an address.
 
D

Don Guillett

fy is a column name 2007 is a row number
Why? can't you name it _fy2007 or fy_2007
 
K

Ken Johnson

re: xl2k

I am attempting to name a column as "fy2007"

xl refuses to accept this. Why?

Note that "fy2007" appears to satisfy all the naming
guidelines, as listed in the help file.

Also note, "fy_2007" is acceptable.

cheers, jw
Click to expand...

fy2007 doesn't satisfy the "Can't be a like a cell address" guidline.
xl2000 only has 256 columns but what about when they release an excel
version with at least 2007 columns? Then your worksheet would have
problems in that version if that guidline was restricted to the
current version's number of columns.

Ken Johnson
 
P

PCLIVE

Because fy2007 is actually a cell reference. That is...column FY and row
2007.

Regards,
Paul
 
K

Ken Johnson

fy2007 doesn't satisfy the "Can't be a like a cell address" guidline.
xl2000 only has 256 columns but what about when they release an excel
version with at least 2007 columns? Then your worksheet would have
problems in that version if that guidline was restricted to the
current version's number of columns.

Ken Johnson
Click to expand...

Oops!
I confused columns and rows.
Excel2000 has over 65000 rows so fy2007 doesn't satisfy the "Can't be
a like a cell address" guidline.

Ken Johnson
 
M

mr_unreliable

Thanks for your replies.

It didn't dawn on me that fy was a legitimate column identifier,
as I rarely (if ever) get beyond the first alphabet.

cheers, jw
 
D

Dave Peterson

Just a warning...

If you're using xl2003 or below, be careful. You'll want to stay away from
names that look like addresses in xl2007 (million rows by 16k columns).

If/when you upgrade to xl2007, you'll be happy that you don't have to fix these
names.
 
S

Shane Devenshire

Which is to say XFD1048576 is a cell address! Which means that some legal
names in 2003 aren't legal in 2007.

Cheers,
Shane
 
S

Stan Brown

Thu, 24 Jan 2008 17:53:11 -0600 from Dave Peterson
If you're using xl2003 or below, be careful. You'll want to stay
away from names that look like addresses in xl2007 (million rows by
16k columns).

If/when you upgrade to xl2007, you'll be happy that you don't have
to fix these names.
Click to expand...

I was wondering about that. If I have a defined name JJ2 in my Excel
2003 workbook, and it points to a single cell, and somewhere I have a
formula =JJ2+11, what does Excel 2007 do with that?

One would hope it gives priority to user-defined names, but .....
 
Top