Excel VBA 7x slower on one computer vs another, new Office 2007 installation

jhobe

New Member
Joined
Jan 5, 2011
Messages
1
All,
Our company recently updated all computers to Office 2007. I had written an Excel/VBA application in 2003 which ran very fast. After updating to 2007 the application runs about 7x slower than before. I think it may be an Office 2007 setting (outside of Excel) since the application still runs just as fast as before on another person's (comparable) computer. I verified that all of the settings in the "Excel Options" tab are the same between the two computers.
Are there other settings/parameters in Office 2007 installation/setup which may be slowing down my Excel/VBA application?
We're running WindowsXP,sp3
Thanks for your help/suggestions
 

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
Hello and welcome to The Board.
I don't have a specific answer for you - perhaps my reply will bring the post to the attention of other who may have some ideas.
I know that there were many comments on the slower speed of 2007 when it was released but I don't know whether that is still an issue.
I would check that all PCs have the latest Office 2007 service pack installed.
In order to compare the performance on two machines you need to make sure that there are running in the same "state". For example, only the one workbook open (Excel will usually calculate all open workbooks at the same time). Do both have the same number of processers and same amount of memory? Where there is more than one processor there is a multi-threading option in Excel (don't think it makes a difference for VBA).
Is disk fragmentation an issue?
If opening and running on a network drive, are both PCs testing the workbook at the same time (that is, is the network load about the same)?
Here are two links that may be useful:
http://technet.microsoft.com/en-us/library/cc179188(office.12).aspx
http://msdn.microsoft.com/en-us/library/aa730921(v=office.12).aspx
 

Forum statistics

Threads
1,081,441
Messages
5,358,705
Members
400,508
Latest member
fish31

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top