Oh! Made a mistake. Please ignore my previous post. I wrongly read the
Bal001 as Ba1001.

--------------------
(Ms-Exl-Learner)
--------------------


"Ms-Exl-Learner" wrote:

I dont think so it is a new one in Excel 2007, because since Excel 2000 to
2003 the Rows are 65536 and the columns are 256 (I dont know about the prior
versions which is prior to Excel 2000). So you cant able define the Ba1001
in the above versions also.

But In Excel 2007 and 2010 the number of Rows has been increased to 1048576
and columns are 16384, so you cant able to define the names from A1 to
XFD1048576 in Excel 2007 & 2010.

--------------------
(Ms-Exl-Learner)
--------------------


"Kevryl" wrote:

OK, so I started the experiment and soon got pulled up. I'm saving my .xls
file as a binary .xlsb, and the darned thing wants to put an underscore in
front of range names. I dunno if it applies to all, but the first one not
acceptable was Bal001. Aah yes, would this be because Bal001 is now an actual
cell within the new Excel 2007 spreadsheet size?

I've got a feeling that's probably the case. If so are there any other new
restrictions on range names since Excel 2000?