Discussion Locked

Excel Files Hang up on open

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am running Excel 2000 on my windows 98 SE with 64MB of RAM and 350MHZ processor . There are times when Excel files take a considerable amount of time to open and at times causes my system to freeze. These files reside on my network. This did not used to happen, but lately is happening on different machines with equal RAM or higher processor speed. I checked Server Task Manager to see how much memory is being consummed by processes, but memory and processor use seems find. Please Help!

7 replies

by taiseermustafa

In a similar case, but faced with Power point files, it caused me to reinstall the OS completely, I tried to reinstall office, uninstall, update to SR1, but nothing helped...I am afraid that you need a clean installation for your OS.

good luck

by cleg

Here are my guesses:

1) Files are corrupt in some way. I have had files that produced the same effect you describe, being slow to open and sometimes locking or causing a gpf. If you work with large Excel files or a lot of forms and controls, you sometimes run into this especially if you save the file frequently. You can decrease the size of the file and 'clean' some corruption by exporting all forms/modules/sheets, deleting them and then reimporting them.
2) Also experienced something similar with a virus shield program running. In this instance, the anti-virus program was scanning ALL add-ins (installed or not) when the file opened. This caused huges delays while opening and appeared to be locked (but if you waited long enough it finished).

by gdunc65

It is best to copy any files locally onto your harddrive from the Network instead of actually opening them across the Network. There is a number of things that can cause the problems you are having, heavy traffic on the Network or configuration changes on the Network.

Hope this helps.

This discussion is closed to new replies.