Cannot open a excel file in excel 2000

[jadering]

I cannot open a excel file in excel 2000 whenever the file goes frozen and the program has to be turned off using Ctrl+Alt+Del. However, I can open other excel files when this happened. The file has about 30 spreadsheets and 15 macros in it. And the size of the file is about 14MB.

This problem has occurred three times before and each time I have to reformat my hard disk in order to get it run again (I have tried to just reinstall office 2000 but failed).

Do you know why this happens and how to fix it?

Many thanks.

Jadering

 

[pcdaveh]

Sounds like that excel file is corrupt. I'm not marketing a product so go to this link and choose.

http://www.google.com/search?q="Corrupt+Excel+File"

 

[jadering]

Thanks for your recommendation. I'd like to get the answer to the following question before making the purchase decision.

I met the above problem at work. In the past, whenever this happened, I made a copy of the corrupted excel file and stored it on a network drive. The file can be opened on other terminals. So I kept on working on it until my machine is reformatted and ready for use. Then I moved the file back to my local drive and kept going.

I don't know if the above way is appropriate for a mission critical VBA project? Hope someone can give me an answer before some real painful things happen.

Thanks a lot.

Jadering

 

[Hasit]

The reason why you can't open the file once Excel freezes is because there is a lock on the file. When you copy it to another location, it is "clean" and a lock can be placed on the newer version of the file.

14MB isn't huge, but is rather unwieldy, which may be causing a problem for Excel, particularly if your system doesn't have appropriate resources etc etc.

The other issue may be that you created the spreadsheet under a different version of Excel, elements of which the 2000 version does not like.

I am not sure that I would buy the anti corruption tool for this reason (although it is an excellent idea to do so anyway), but rather work out why the file freezes in the first instance.