detect cells with links

H

Hugh Hoffman

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
 
T

tim m

Have you looked at 'Tools'...'formula auditing'....then trace precedants and
dependants?
 
H

Hugh Hoffman

Yes, and it will show me the linked workbook only if I place my cursor on the
appropriate cell, on the cell that has the link with that workbook, if I do
not place myself on the corresponding cell, I have not found I way to detect
which cells contain such type of linkage
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
H

Hugh Hoffman

Thank you so much MASTER

Ken Wright said:
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 :)
------------------------------­------------------------------­----------------
Click to expand...
 
Top