SOLVED

Excel - breaking links to another file

%3CLINGO-SUB%20id%3D%22lingo-sub-1547965%22%20slang%3D%22en-US%22%3EExcel%20-%20breaking%20links%20to%20another%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547965%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%E2%80%93%20I%20am%20struggling%20to%20remove%201%20of%20multiple%20links.%3C%2FP%3E%3CP%3EHave%20tried%20all%20advises%20how%20to%20break%20a%20link%20but%20it%20doesn't%20help.%3C%2FP%3E%3CP%3EAnyone%20who%20have%20an%20idea%20%E2%80%93%20is%20there%20a%20%E2%80%9Csafe%E2%80%9D%20add%20in%20%3F%3C%2FP%3E%3CP%3EKind%20regards%3CBR%20%2F%3EOCM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1547965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1560513%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20breaking%20links%20to%20another%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1560513%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F741088%22%20target%3D%22_blank%22%3E%40omatthie%3C%2FA%3E%26nbsp%3B%2C%20Try%20this%20add-in%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EFindLink%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1566078%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20breaking%20links%20to%20another%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1566078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFantastic%20%E2%80%93%20Your%20suggested%20add%20in%20solved%20my%20problem.%3C%2FP%3E%3CP%3EThe%20problem%20was%20that%20I%20had%20%E2%80%9Chidden%E2%80%9D%20the%20link%20in%20a%20Data%20validation%2C%20hence%20there%20was%20no%20link%20reference%20in%20the%20cell.%26nbsp%3B%20However%2C%20your%20add%20in%20pointed%20out%20the%20correct%20cell%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1703620%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20breaking%20links%20to%20another%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1703620%22%20slang%3D%22en-US%22%3EThis%20is%20the%20best%20answer!!!%3C%2FLINGO-BODY%3E
New Contributor

Hi – I am struggling to remove 1 of multiple links.

Have tried all advises how to break a link but it doesn't help.

Anyone who have an idea – is there a “safe” add in ?

Kind regards
OCM

3 Replies
Best Response confirmed by omatthie (New Contributor)
Solution

@omatthie , Try this add-in:

 

FindLink

@TheAntony 

Fantastic – Your suggested add in solved my problem.

The problem was that I had “hidden” the link in a Data validation, hence there was no link reference in the cell.  However, your add in pointed out the correct cell

Thank you

This is the best answer!!!