A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

More on saving as binary.



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 11:32 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default More on saving as binary.

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?
  #2  
Old June 1st, 2010, 12:14 PM posted to microsoft.public.excel.misc
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default More on saving as binary.

I don’t 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 don’t know about the prior
versions which is prior to Excel 2000). So you can’t 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 can’t 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?

  #3  
Old June 1st, 2010, 03:33 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default More on saving as binary.

You are correct.

Bal001 is a cell address in 2007

Hence the underscore.


Gord Dibben MS Excel MVP


On Tue, 1 Jun 2010 03:32:01 -0700, 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?


  #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?



  #5  
Old June 1st, 2010, 04:22 PM posted to microsoft.public.excel.misc
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default More on saving as binary.

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

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


"Ms-Exl-Learner" wrote:

I don’t 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 don’t know about the prior
versions which is prior to Excel 2000). So you can’t 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 can’t 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?

  #6  
Old June 2nd, 2010, 05:10 AM posted to microsoft.public.excel.misc
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default More on saving as binary.

and this behaviour is not only with Excel 2007...but also with the previous
versions.

--
Jacob (MVP - Excel)


"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?

  #7  
Old June 3rd, 2010, 06:22 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default More on saving as binary.

Thanks folks, I shoulda twigged to that sooner. It means there's not too many
range names (and macros) I'll need to change if I save as 2007 files. Heaps
of range names but very few that could be a cell address.

"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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.