[I wrote this some time ago (pre release), but I thought I would stick out there as its still relevant, and I havent done much more on 2010 since]
I’ve been playing around with twenty ten, and reading around some of the features. Bear in mind though this is pre release, so it may be missing some polish etc.
Here are those features I consider most important.
- You can still insert and write XLM. (So what? – XLM UDFs can be way faster than VBA ones, XLM used to cover a few thins you could not do in VBA (they are addressing these VBA gaps). But also XLM is the best guidance we have for VBA’s lifetime – and its looking like 2023 minimum) (2010 + 2010 – 1997))
- VBA still primary development environment, no obvious changes from 1997 IDE.
- VBA got ported to 64 bit – so its going to be around for some time.
- There is a new xll SDK – suggesting this will still be the add-in technology of choice.
- UI Customisation is back, programmability will probably reappear in V next +1, then we will just need to able able to adjust the ribbon size and orientate it at the side, and maybe drag and drop, and we will be back at 1995 (or earlier?), minus a few bazillion dollars of course.
- Base UI appears consistent with 2007 which is a relief
- Massive re-write of key stats functions
- High performance cluster stuff sounds like they are serious about Excel as a calc engine for serious application, especially with the new massive file size potential of 64 bit.
So in summary 2010 is reassuring to me, the 2007 noddy UI worried me that MS think Excel is for numpties and kids. 2010 suggests they see very serious applications.
Killer features to persuade you to migrate? Dunno, I’m not sure the real value proposition is in the client alone anymore. But I will move I think.
Are you live on 2010? what do you think? (some people are calling it O2007 SP3)