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.

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.

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" wrote:

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.