Daily posts of Excel tips…and other stuff
David Gainer, the Group Program Manager for Excel at Microsoft, has just started a blog about Excel 12, in which he’ll be introducing all the new features that Excel 12 will bring. See it now at http://blogs.msdn.com/excel/default.aspx
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Rob van Gelder:
Great First Post! - If only I was a betting man, I’d be $5 richer
23 September 2005, 5:33 amross:
wow, all those cells - i feel faint!
23 September 2005, 6:38 amDick Kusleika:
Only 17 billion cells? Why do they limit me so?
23 September 2005, 7:30 amXL-Dennis:
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,
23 September 2005, 7:46 amDennis
ross:
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!
23 September 2005, 8:29 amXL-Dennis:
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,
23 September 2005, 4:00 pmDennis
Rob van Gelder:
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.
Cheers,
23 September 2005, 6:27 pmRob
Jon Peltier:
You go, Rob. That’s enough for each minute of that fortnight!
- Jon
23 September 2005, 7:23 pmIvan F Moala:
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 ..
23 September 2005, 10:57 pmross:
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!
24 September 2005, 9:52 am