Home

finding external links

%3CLINGO-SUB%20id%3D%22lingo-sub-279225%22%20slang%3D%22en-US%22%3Efinding%20external%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279225%22%20slang%3D%22en-US%22%3E%3CP%3Eplease%20advise%20about%20finding%20and%20breaking%20external%20links%20in%20an%20excel%20workbook%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20I%20use%26nbsp%3B%20Data%2FEdit%20Links%2C%20it%20shows%202%20sources%2C%20(1%20is%20type%2Fworksheet%2C%201%20is%20type%2Fremote%20file)%3C%2FP%3E%3CP%3Ehowever%2C%20manually%20breaking%20the%20link%20has%20no%20impact%20on%20those%20two%20sources%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20trying%20to%20find%20the%20links%20I%20have%20been%20using%20this%20sequence%20and%20I%20get%20no%20results%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Econtrol%20F%3C%2FP%3E%3CP%3Efind%20what%3A%26nbsp%3B%26nbsp%3B%20.xl%20(no%20format%20set)%3C%2FP%3E%3CP%3Ewithin%3A%26nbsp%3B%26nbsp%3B%20workbook%3C%2FP%3E%3CP%3Esearch%3A%26nbsp%3B%20by%20rows%3C%2FP%3E%3CP%3Elook%20in%3A%26nbsp%3B%20formulas%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-279225%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279253%22%20slang%3D%22en-US%22%3ERe%3A%20finding%20external%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279253%22%20slang%3D%22en-US%22%3EYou%20can%20use%20the%20free%20Excel%20Add-In%20%3CA%20href%3D%22http%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%20%3CBR%20%2F%3Eto%20find%20your%20links.%3CBR%20%2F%3E%3CBR%20%2F%3Ealso%20check%20if%20your%20excel%20named%20range%20uses%20the%20links.%20Because%2C%20if%20your%20named%20range%20uses%20the%20link%2C%20you%20cannot%20delete%20the%20link%2C%20unless%20you%20delete%20or%20modify%20that%20named%20range.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

please advise about finding and breaking external links in an excel workbook

 

when I use  Data/Edit Links, it shows 2 sources, (1 is type/worksheet, 1 is type/remote file)

however, manually breaking the link has no impact on those two sources

 

when trying to find the links I have been using this sequence and I get no results

 

control F

find what:   .xl (no format set)

within:   workbook

search:  by rows

look in:  formulas

 

 

1 Reply
Highlighted
You can use the free Excel Add-In http://www.manville.org.uk/software/findlink.htm
to find your links.

also check if your excel named range uses the links. Because, if your named range uses the link, you cannot delete the link, unless you delete or modify that named range.
Related Conversations
Why cant i share files in an external chat?
jerrodbug in Microsoft Teams on
1 Replies
Getting link to Posts Tab
darren365 in Microsoft Teams on
3 Replies
Links in Planner Task Notes are active!
Robin Nilsson in Planner on
0 Replies
Copying Links to Paragraphs in OneNote
kayla7 in Office 365 on
2 Replies