MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding Linked Cells!?


Posted by JJ on November 23, 2001 8:19 AM

How do you find Cells within a spreadsheet that have links in them? (other than using the show/hide formulas shortcut)


Posted by Bib on November 23, 2001 8:49 AM

Do a research (ctrl+F) for the linked filename in every sheet of your workbook.

To remove the links, go to Edit/Links/update and select the file itself.

Posted by JJ on November 23, 2001 9:05 AM


ok, thanks...

what if I dont know or cannot remember the name of a link, or perhaps there's a number of them!?

Posted by Bib on November 23, 2001 9:15 AM


The list of the links is is Edit/Links...
If many, do them one by one. If you do this often, write a macro to do it for you, using ActiveWorkbook.LinkSources property and ActiveWorkbook.ChangeLink method

Regards