Excel won't run properly?!?

[Allan73]

When I open Excel 2000 it runs ok. If I open a small file it runs ok. If I open a file around 1MB or upwards it opens b ut the timer is there for ages, and then the workbook opens but is inactive. I can then use it but 1 mouse click can take about 4-5 minutes!

If I open task manager Excel appears to be running around 50%-70% CPU usage.

I also believe this has now happened on 2-3 other networked machines, do I have a virus?

Any help greatly appreciated, my users are losing it!!

 

[Dreamboat]

Sounds to me more like corrupt files. Open those files and try copying the sheets to a new workbook. If that doesn't work, come on back and say so. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[Allan73]

I've sent the files to my laptop and I am able to open them without a problem, so the files themselves aren't corrupt.

This also appears now to have propogated itself into Word as well.

 

[jredmon]

What operating system is on the workstation, and the servers? Are your domain controllers using a different OS version than the file servers?

There are several micro$oft bugs that can cause this same issue. We were fighting this for a while until we upgraded the workstations from Windows 98 to Windows 2000.

 

[Allan73]

Workstations are running Win2k, server is running 2k as well.

We're running out of ideas on this one, I've tried re installing office, tried re installing Excel alone, but to no avail.

 

[jredmon]

Is the domain controller NT 4.0 by any chance?

 

[Allan73]

Yeah the PDC is NT4

 

[jredmon]

If you put the file on the workstation, it opens fine? But on the server, it drags? There is something about that on Micro$ofts website, the file server is having problems get authentication from the DC. Before a file can be opened, the file server checks the DC to see if you were authenticated, then it checks the permissions on the folder. There is something between your DC and the file server.

Try installing all the patches and updates for Windows 2k and for Office. Office has SP3 out now and it's been okay for us, no problems with it except of course it forces you to install the outlook patch that some people dreaded, but we are no longer having the issue.

Make sure to install all patches and updates on both the DC and file server.

Good luck.

 

[Allan73]

OK cool, thanks redmon, i'll give it a shot and let you know what happens!

 

[Allan73]

Well the problem has now been resolved.

It was an issue with an HP Laserjet printer on the network that was causing the issue, I'm not 100% sure why as a colleague of mine sorted it out whilst I was doing something else, but it appears that the default printer was conflicting in some way with it and as a result Excel wasn't running.

Having removed the default printer, and simply chaing the default, it has now stopped crashing Excel.....bizarre!

Thanks guys for trying!