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