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

  • Thread starter Thread starter GOH
  • Start date Start date
G

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?
 
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.
 
GOH said:
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?
Click to expand...
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
 
Thanks bob, unfortunately the recovered file convert everything to
text......all the formula are gone!
 
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.
 
Back
Top