More on saving as binary.
in [General]
|
Prev: Chart Help
Next: Deleting invisible range names - how?
From: Kevryl on 1 Jun 2010 06:32 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?
From: Ms-Exl-Learner on 1 Jun 2010 07:14 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?
From: Gord Dibben on 1 Jun 2010 10:33 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 <Kevryl(a)discussions.microsoft.com> 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?
From: T. Valko on 1 Jun 2010 10:34 >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" <Kevryl(a)discussions.microsoft.com> wrote in message news:6327ABCA-7FCE-4942-9B5A-9156EC996C75(a)microsoft.com... > 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?
From: Ms-Exl-Learner on 1 Jun 2010 11:22
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? |