Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2007 Sheet Size? (Excel 2007) - RESOLVED

    I have the Beta Release of Office Professional 2007 and have looked all over to try and find just how large this sheet is on the Internet this morning to no avail. I notice that it has 1048576 Rows Now and the columns go all the way to XFD. I'm not up to the math...really I'm not. Does anyone know the exact count of Columns X Rows to give me the Cell count of the new spreadsheet?
    Thanks
    About the time I ask, I find it...sorry...well if anyone else wants to know it is 1048576 Rows * 16384 Columns which would equal an astonishing 17,179,869,184 Cells on one sheet. I found it by clicking on the "all cells" square in the top left utmost corner of the sheet, to the left of the A and above the number 1 in the spreadsheet...the coordinates are then seen in the Name Box above that.
    Anyone know the reasoning behind this exact number? As Excel 2003 had 16, 777, 216 cells on a sheet or 256 Columns X 65,536 rows, and know that was based on the binary system of the columns being (2^8) and the rows being (2^16)....
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel 2007 Sheet Size? (Excel 2007) - RESOLVED

    and now the rows will be 2^20 and the columns 2^14, which I guess has something to do with word sizes.
    I suspect there will be a lot of horrendous spreadsheets as a result...
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2007 Sheet Size? (Excel 2007) - RESOLVED

    Thanks Rory...I can expect so...(ha-ha) And Expect Named ranges will be used a whole lot more.
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •