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 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?

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?

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?

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