Processing Time Varies
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
on one PC.
"Paige" wrote:
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.
|