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

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 to savage a file that crashes? "Microsoft encounter a problem.
 

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 wrote:

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 to savage a file that crashes? "Microsoft encounter a problem.
 

GOH wrote:
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

How to savage a file that crashes? "Microsoft encounter a prob
 

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


"Bob I" wrote:

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 wrote:

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 to savage a file that crashes? "Microsoft encounter a prob
 

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.

GOH wrote:

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


"Bob I" wrote:


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 wrote:


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?