10 thoughts on “Official Excel 12 Blog

  1. For users with a *really* need this is a welcome improvement.

    Hm, I can only hope that users use this available capacity with good judgement, i e not to believe that it’s a good place to store historical / irrelevant data in.

    I wonder what this will mean when it comes to filesize, performance and stability of the workbooks.

    After all, Excel is still a spreadsheet software and not a flat database tool ;)

    Kind regards,

  2. arrrrr come on Dennis! you and I both know that people are going to store loads of data in excel now!

    I think it’s time to maybe start thinking/looking trying to make excel in to a simple DB – well give better tools than current versions! Becasue people will use it like a BD, for sure!

  3. Sorry Ross!

    We look forward to see post on public Excel forums with questions like “I got a 1 TB file and I wonder why Excel is so slow?” ;)

    Seriously, I really want to see that Excel is used for it’s mainpurpose and as the UI for presentation of DSS-data.

    Kind regards,

  4. Just to add my 2c. (It’s more like 1c when you consider the exchange rate)

    I personally feel that 65536 rows is plenty.
    If I need more than that, then I’m doing something wrong.

    256 columns, on the other hand, is just not enough.
    One app that comes to mind is a 14 day look ahead gantt chart. I’ll be able to dedicate 1 column to each hour of that fortnight, something I can’t do at the moment without spilling to a second sheet.


  5. I have to agree with Rob, 65536 is plenty, if we go over this then we need to ask if we are using it eff. or the right application. Columns however … we need more of ..

  6. Yeah, thats a good point!!! 65536 is a lot of rows, but 255 cols?, I wounder if some better formations could have been found?

    I klnow that the limits are to do with computers internal workings (someting to do with binary progressions?), but could there logical be differnt grid formations? i.e total calls = 65536*255, but in a diffrent way – not that it matter much now of course!

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.