How can you delete a broken link in an excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2620608%22%20slang%3D%22en-US%22%3EHow%20can%20you%20delete%20a%20broken%20link%20in%20an%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620608%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20you%20delete%20a%20broken%20link%20in%20an%20excel%20workbook%20when%20break%20link%20doesn't%20work.%26nbsp%3B%20I%20don't%20want%20to%20link%20to%20this%20file%20which%20source%20can't%20be%20found%2C%20I%20just%20want%20to%20continue%20to%20use%20the%20workbook%20and%20delete%20the%20link%20permanently.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2620608%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2620626%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20delete%20a%20broken%20link%20in%20an%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2620626%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1122343%22%20target%3D%22_blank%22%3E%40Alison_Chard%3C%2FA%3E%26nbsp%3BUse%20the%20tool%20in%20the%20attached%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2623826%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20you%20delete%20a%20broken%20link%20in%20an%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2623826%22%20slang%3D%22en-US%22%3E%3CP%3EI%20came%20across%20a%20VBA%20script%20in%20blogger%20that%20allows%20you%20to%20either%20clear%20the%20broken%20links%20or%20to%20replace%20them%2C%20this%20is%20the%20link%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20title%3D%22removing%20and%20modifying%20broken%20links%22%20href%3D%22https%3A%2F%2Fmartinbosanacvba.blogspot.com%2F2021%2F08%2Fremoving-and-modifying-broken-links-in.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eremoving%20and%20modifying%20broken%20links%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

How can you delete a broken link in an excel workbook when break link doesn't work.  I don't want to link to this file which source can't be found, I just want to continue to use the workbook and delete the link permanently.

2 Replies

I came across a VBA script in blogger that allows you to either clear the broken links or to replace them, this is the link:

removing and modifying broken links