Use Bill Manville's free FINDLINK addin

http://www.oaltd.co.uk/MVP/Default.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Hugh Hoffman" <Hugh wrote in message
...
How can I detect on an excel workbook which cell have links(formula =) to
other workbooks without have to put my cursor on top of each linked cell.
I
have had a hard time finding this cells. I can see the links by choosing
Edit
then links, and excel will display list of links, but it does not specify
which cells contain those links