Excel 2010 vs 2013 Speed Benchmark
In a recent comment, someone noted:
If you try to experiment your previous macros, you will find that they will take longer to run.
I haven't noticed any significant speed differences, so I did a quick search for a speed test and found this: Excel Benchmark 2011- An Excel VBA Speed Test. I ran the benchmark on Excel 2010 and got this:
On Excel 2013, I got this:
According to this, Excel 2013 is a bit faster. Not much faster, but it's certainly not slower.
- Reader Comments -
Following are comments in response to this item.
The most recent comment is at the bottom.
- By Butch Barker. Comment posted 04 November, 2012 5:20amI don't understand, it seems to me that it shows 2013 as being slower
- By John Walkenbach. Comment posted 07 November, 2012 5:06pmI haven't taken the time to learn about this benchmark, but a higher score is better. If somebody notices some significantly slower macro performance, I'd be interested to hear about it.
- By Erik Westwig. Comment posted 20 November, 2012 12:14pmI did a test with recalcing a single Rand function a zillion times, and I found 2013 to be half as fast as 2010 on the same (Windows 7 machine).
- By Jim Cone. Comment posted 15 January, 2013 11:17pmFor what it is worth...
Excel 2003 score: 74.84
Excel 2010 score: 64.24
Memory: 3.49 GB
Windows XP, Intel Pentium Xeon @ 3199
- By Steve Farrar. Comment posted 25 January, 2013 7:26amI have some macros that run at about the same speed but I have at least 2 where it takes way too long to run- fortunately I did not remove Excel 2010 so I can run them using that --but Microsoft needs to fix this!!!
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.