Hi xk,

It isn't hard to find links without a macro. Simply use Edit|Links and
you'll usually be able to see the first source file's path and filename
listed against 'source file:'. If your workbook is linked to more than one
file, selecting each in turn will reveal it full details. So, now all you
need to do is a 'find' for those.

Cheers

--
macropod
[MVP - Microsoft Word]


"xk" wrote in message
...
Hi,

When I open a excel file, there is prompt indicating there are link in
this
file.
Since this file has so much sheet and data, is there anyway that I can
use
it in Macro to find this linked cell ?

Thanks

xk