Processing Time Varies

[Paige]

I have a large Excel file with lots of coding. When I run the code, it
takes, for example 5 minutes to complete. When another person (on another
computer) runs it, it takes 2 hours to finish. It is the only file open at
the time for both of us, we are both in the same states of calculation, and
we both have the same processor speed/RAM, so what else could be causing
this. Could it have anything to do with VBA references that I have that they
don't? Am just reaching here but have no idea as to what is causing this
discrepancy. Any thoughts would be appreciated; I have to get this resolved
and am at my wits end.

 

[Joel]

Move the file to a local drive on each PC (C:\) to determine if the problem
is a network connection.

You can check your network speed by going to control panel - Network
Connections - Local Area Connection. Or looking at the task Manager Network
window.

There may be some spy ware software runing in the background on the slow
machine. Try running code on a couple more PC to see if it is only a problem

 

[Paige]

Thanks, Joel. I should have said - they are already just running on a local
drive, not network connected. And the slow processing time does happen on
one other machine that I'm aware of so far. We all have Excel 2003, same SP,
and same OS. I thought it might be an issue possibly with Windows XP service
packs/updates, but we work for a large company and all those are
automatically "pushed" and installed.

 

[Joel]

I would start comparing Processes in the Task Manager to see if there are any
differences. Sort the process alphabetically by pressing Image Name. To get
a picture of the Task Manager screen I often Press Cntl - Print Screen (upper
right side of keyboard). Then open Power Point and paste the image into
Power Point. Then print the results.

This way you have on paper the processes on the two machines and start
looking for differences. I would also try having two different people
logging and running the macro to see if there is something in a user startup
script that is causing the problem.

 

[Paige]

Good idea. Will do that; thanks for the input!

I would start comparing Processes in the Task Manager to see if there are any
differences. Sort the process alphabetically by pressing Image Name. To get
a picture of the Task Manager screen I often Press Cntl - Print Screen (upper
right side of keyboard). Then open Power Point and paste the image into
Power Point. Then print the results.

This way you have on paper the processes on the two machines and start
looking for differences. I would also try having two different people
logging and running the macro to see if there is something in a user startup
script that is causing the problem.

 

[Jim Thomlinson]

One thing you could look for would be to see if the user getting the slow
performance has any addins or other spreadsheets open. If there is event code
firing or volatile functions then that could affect performance...