There are many differences between Excel 2003 and 2007. There are far fewer differences between Excel 2007 and Excel 2010. Should you upgrade? Very tough call. We thought we would list the differences that we see that are important to most users:
- Chart macro recording has been fixed in 2010. Not something to be proud of since it should not have been broken when Excel 2007 was released, and should have been fixed in an SP release. If you need to record chart macros, which is a need if writing such macros, then you need 2010.
- The calculation speed is a little faster. For 99% of users, no one will notice the difference.
- Sparklines are nice. Maybe worth the upgrade. They are little mini-charts.
- Excel 2010 can be run as a 64 bit application. But one can not install it as part of the automatic install. One has to dig on the disk to find it. And you need to have at least 5-10 gig of memory on your PC to significantly benefit from it. Most PCs have at most 3 gig, which is far to little. And few users need 64 bit Excel. But it does sound impressive to say you are using it!
- Microsoft improved statistical, financial, and math functions and the wizard interface in 2010. We're glad the functions are better, but upgrade only if you are aware of a problem with functions in your older copy of Excel or if you need a function that is not in your copy of Excel.
- Fill patterns which were removed in 2007 are back. Howeve do not upgrade just to get fill patterns back. A quick search on the internet will find several free fill pattern add-ins for Excel 2007.
- If you are a heavy user of conditional formatting, then upgrading to 2010 should benefit you. In 2007, a lot of conditional formatting would bring Excel to its knees.
If you were pushing the envelope of what you needed Excel to do, then upgrading is probably a good idea, especially if you have Excel 2007. If you are on 2003, upgrading to 2010 will most likely cut your productivity 20% at least. See our page above on 2003 versus 2007. If you are the average user, developing typical workbooks and your version of Excel is working fine, stay with it and don't upgrade.