How to delete Link to removed documents

%3CLINGO-SUB%20id%3D%22lingo-sub-1572688%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20Link%20to%20removed%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572688%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%3A%20in%20the%20Excelsheet%20I%20need%20to%20work%20in%2C%20there%20are%20three%20links%20to%20documents%20that%20have%20been%20removed%20or%20deleted.%20How%20can%20I%20delete%20these%20links%3F%3C%2FP%3E%3CP%3EWhen%20I%20follow%20the%20normal%20description%20it%20doesn't%20work%3A%20I%20do%20pres%20on%20delete%20link%20but%20nothing%20happends.%20I%20guess%20because%20the%20linked%20document%20is%20gone.%3C%2FP%3E%3CP%3EThis%20is%20the%20dutch%20article%20I%20used%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fnl-nl%2Foffice%2Feen-koppeling-verbreken-met-een-externe-verwijzing-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fnl-nl%2Foffice%2Feen-koppeling-verbreken-met-een-externe-verwijzing-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20sincerely%20that%20someone%20can%20help%20me.%3C%2FP%3E%3CP%3ELove%2C%3C%2FP%3E%3CP%3EGongon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1572688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572733%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20Link%20to%20removed%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F569240%22%20target%3D%22_blank%22%3E%40Gongon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20recommend%20to%20use%20FindLink%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572900%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20delete%20Link%20to%20removed%20documents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572900%22%20slang%3D%22de-DE%22%3EIf%20you%20want%20to%20search%20for%20and%20remove%20hyperlinks%20in%20the%20specific%20area%20%2F%20cells%2C%20have%20a%20look%20at%20this%20entry%20..%20is%20For%20Excel%202013%2C2016%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2013%2F09%2F20%2Fremove-hyperlinks-from-excel%2F%23remove-multiple-hyperlinks%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2013%2F09%2F20%2Fremove-hyperlinks-from-excel%2F%23remove-multiple-hyperlinks%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Most%20of%20them%20are%20hidden%20hyperlinks%20in%20the%20conditional%20formatting%20of%20the%20cells.%20To%20delete%20them%2C%20follow%20the%20steps%20below.%20%3CBR%20%2F%3E%20Go%20to%20the%20Home%20tab%20-%26gt%3B%20Conditional%20Formatting%20-%26gt%3B%20Manage%20Rules%20-%26gt%3B%20Delete%20rules%20in%20the%20entire%20sheet%20-%26gt%3B%20OK.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Dear everyone,

 

I have a problem: in the Excelsheet I need to work in, there are three links to documents that have been removed or deleted. How can I delete these links?

When I follow the normal description it doesn't work: I do pres on delete link but nothing happends. I guess because the linked document is gone.

This is the dutch article I used: https://support.microsoft.com/nl-nl/office/een-koppeling-verbreken-met-een-externe-verwijzing-in-exc...

 

I hope sincerely that someone can help me.

Love,

Gongon

2 Replies
If you want to search for and remove hyperlinks in the specific area / cells, have a look at this entry .. is For Excel 2013,2016

https://www.ablebits.com/office-addins-blog/2013/09/20/remove-hyperlinks-from-excel/#remove-multiple...

Most of them are hidden hyperlinks in the conditional formatting of the cells. To delete them, follow the steps below.
Go to the Home tab –> Conditional Formatting –> Manage Rules –> Delete rules in the entire sheet –> OK.