RE: Processing Time Varies

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

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.
.

Relevant Pages

  • RE: Processing Time Varies
    ... Sort the process alphabetically by pressing Image Name. ... drive, not network connected. ... is a network connection. ... Or looking at the task Manager Network ...
    (microsoft.public.excel.programming)
  • Re: Computer does not recognize printer attached to another comput
    ... This was the very first thing I did when I thought of MOM being able to use ... I tried network connection 3 ways - using the XP cd, ... than just simply turn sharing on or off. ... use the Network Connection Wizard in All Programs> Accessories ...
    (microsoft.public.windowsxp.print_fax)
  • Re: What would prevent an ISAPI extension from opening a socket on IIS 6?
    ... Both fail when they try to make that network ... way as to make opening any network connection impossible. ... > on your Windows Server 2003 but not your customer's? ... > through ISAPI Filters. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Error when accessing Network Properties
    ... when I attempt to access my Network Connections ... "Windows could not load the installer for NET. ... Intel PRO/100 VE Network Connection ... WAN Miniport - Packet Scheduler Miniport ...
    (microsoft.public.windowsxp.network_web)
  • Re: No "Protocol" Tab
    ... Windows IP Configuration ... PRO/100 VE Network Connecti ... >>properties all I have is a General Tab and nothing else. ... Right-click your network connection and click ...
    (microsoft.public.windowsxp.network_web)