View Single Post
  #4  
Old June 1st, 2010, 03:34 PM posted to microsoft.public.excel.misc
T. Valko
external usenet poster
 
Posts: 15,759
Default More on saving as binary.

would this be because Bal001 is now an
actual cell within the new Excel 2007
spreadsheet size?


Yes, sort of!

There is no actual cell address BAL001 but Excel will interpret that as the
actual cell address BAL1.

Try entering BAL001 in the name box and then hitting Enter. Excel will take
you to cell BAL1.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?