illegal name? [noobie, please be gentle]

  • Thread starter Thread starter mr_unreliable
  • Start date Start date
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
 
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.
 
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
 
Because fy2007 is actually a cell reference. That is...column FY and row
2007.

Regards,
Paul
 
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
 
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
 
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.
 
Which is to say XFD1048576 is a cell address! Which means that some legal
names in 2003 aren't legal in 2007.

Cheers,
Shane
 
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 .....
 
Back
Top