slow Excel 2K3 on WXPSP2

pts.
Tags:
Microsoft Windows XP
I have several users who are tracking reservations in Excel workbooks. The files are opening very slowly, compromising customer service. We are planning to install a custom C-S reservations app, but I need a fix now. The problem is worst on new machines (P4 3.0GHz w/ 512MB RAM) running WinXPsp2 and Office 2K3. It takes 90-120 seconds to open a 500K file. The issue remains if I copy the file from the server to the local machine and open it there. Here's the funny part: If I put the machine in Safe Mode and open the file locally, it opens in <5 seconds. If I turn on RDC and open it from a remote machine, it opens in <5 seconds. There appears to be a lot of network activity happening during the long opening attempts. The files have been trimmed to remove blank cells. I've deleted temp files and checked file associations to make sure they are referencing "%1" to include spaces in the file name. We don't have Text-to-Speech turned on. I've heard that Symantec AntiVirus could be a problem - I've excluded the files, and even turned off Real-time protection. I haven't uninstalled SAV. I've heard that HP print drivers could be a problem. We've changed the driver from HP 1320 back to vanilla HP4. I'm stumped. Any help would be greatly appreciated. -Mike

Answer Wiki

Thanks. We'll let you know when a new response is added.

get a copy of RegMon and run it while opening the file to see what sort of registry activity is going on while the file is being opened.

Also, get a copy of Ethereal (or other sniffer) and see what the traffic looks like during this process.

Bob

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Joelsplace
    I've got the same problem on some but not all machines running Office 2K. Tried moving the file to the local drive with the same results. Didn't try safe mode but did try killing all the sevices I could. It only seems to happen on some Excel files and not others and only on some boxes. ??? I'll try the previous tips. Thanks, Joel
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following