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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,130,281
Messages
5,641,293
Members
417,202
Latest member
AndyVBA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top