detect cells with links
 

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

detect cells with links
 

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

"Hugh Hoffman" wrote:

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

detect cells with links
 

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

"tim m" wrote:

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

"Hugh Hoffman" wrote:

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

detect cells with links
 

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

detect cells with links
 

Thank you so much MASTER

"Ken Wright" wrote:

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

detect cells with links
 

LOL - You're very welcome :-)

"Hugh Hoffman" wrote in message
...
Thank you so much MASTER

"Ken Wright" wrote:

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