edit links

[jakobt]

I go to data and edit links.It appears there are link to another workbook.If I try to break link. The link does not disappear.I try Ctrl + F in the workbook and search for the link, but no search result.How is it possible to delete a link or how is it possible to find where in the workbook it appears.

 

[Trevor G]

Which version of Excel are you using? If using 2013 or greater there is an addin called inquire and this will find links and mucu more. Here is a youtube link, there are loads you can watch. https://www.youtube.com/watch?v=pXZ75XuwsOY

 

[jakobt]

Excellent tip. However, I receive an error when running inquire - workbook analysis report.
Error: listed with red:
Unexpected error while analyzing file...Invalid URI: The hostname could not be parsed?