Jan 7 2009

Is VBA in Excel 2007 Slower Than in Excel 2003?

The Microsoft Excel Blog  has an interesting post about the speed of Excel 2007′s VBA.  Apparently it has come to their attention that in some cases the VBA in Excel 2007 is not running as quick as its 2003 predecessor.   I personally have not come across an instance where this has happened, but apparently many Excel 2007 users have.  The blog even asks users to send them examples of instances of slowdowns so they can actively work on the problem.

[ad#in-post-ad]

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          
TAGS: ,

2 Comments on this post

Trackbacks

  1. G said:

    It would not surprise me. By my own testing, Office 2007 is slower than 2003: http://forums.extremeoverclocking.com/showpost.php?p=2984108&postcount=1

    2007 also adds more syntax, which is going to slow down the processing engine.

    2007 is a piece of crap.

    May 21st, 2009 at 8:20 am
  2. Geoff Morris said:

    I am currently looking around the net for hints on how to speed up VBA in 2007, which is why I end up here.

    In my case, I have a big 20MB database file which uses macros to do some big convoluted number crunching on pretty much all the data at once (mostly regression).

    In 2003, it would take three or four seconds between programmed screen refreshes.

    Recently I opted to let IT upgrade my PC to 2007 (seemed about time, especially since I keep receiving files in the new format). Now when I run the same file it takes TWENTY seconds per refresh!

    That means I’ve gone from a five-minute-cup-of-coffee analysis to a go-do-something-else-for-half-an-hour analysis… which no doubt will actually take longer since now I won’t be keeping an eye on when it finishes! This is a huge step backwards in productivity!!!

    I also noticed that it takes longer to load the database, and with 2003 I could rapidly switch back and forth between two versions of the database using CTRL-TAB to compare graphs of results… that’s no longer possible since it doesn’t draw the graphs until I let go of the keys and pause for a second. >:-(

    Perhaps I could try saving in native 2007 format, but I’m not holding my breath for any miracles.

    December 5th, 2011 at 12:24 pm

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives