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
Raymond Skaug
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
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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies