How to savage a file that crashes? "Microsoft encounter a problem.

[GOH]

I often encounter the problem in opening some of my big excel file - it juz
crashes with a message "microsoft excel encounter a problem....".

I suspect one of the problem is that my excel file has several links to
external sources, including bloomberg links.

How can i prevent this from happening? For those file that already have
problem, is there any way to recover?

 

[Bob I]

If you reopening the "crashed" workbook, Excel will offer to recover it.
Prevent it? Watch what you link to, alot of those "links" will trip
additional links to other scripts and that is where your problem likely is.

 

[Bill Sharpe]

I often encounter the problem in opening some of my big excel file - it juz
crashes with a message "microsoft excel encounter a problem....".

I suspect one of the problem is that my excel file has several links to
external sources, including bloomberg links.

How can i prevent this from happening? For those file that already have
problem, is there any way to recover?

How "big" is your Excel file? Smaller is always better. Can you modify
your file setup so that each Excel file only links to one external
source? That way you may be figure out which source is causing the problem.

Bill

 

[p45cal]

How to savage a file that crashes?Transfer the file to floppy disk, take the disk outside, attack it wit

a large hammer, run over it with a lawn mower, give it to your cat t
maul, finally, put it through a powerful shredder

 

[GOH]

Thanks bob, unfortunately the recovered file convert everything to
text......all the formula are gone!

 

[Bob I]

Until you can remove the problematic links, perhaps you can set Excel to
make a backup copy. Save As, Tools, General Options, Always make a backup.