How to Find and Delete a Link in an Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2746384%22%20slang%3D%22en-US%22%3EHow%20to%20Find%20and%20Delete%20a%20Link%20in%20an%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20My%20Excel%20Indicates%20It%20cannot%20update%20a%20link%20when%20I%20open%20it.%26nbsp%3B%20I%20cant%20see%20any%20link%20in%20the%20Data%20links%2C%20so%20not%20sure%20where%20to%20find%20and%20delete%20the%20link.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20message%20says%3A%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20cant%20connect%20to%20%22%3CA%20href%3D%22https%3A%2F%2FLOCALS~1%2FTemp%2FDOCUME~1%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2FLOCALS~1%2FTemp%2FDOCUME~1%2F%3C%2FA%3E........%20and%20ends%20with%20.xls%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%2C%3C%2FP%3E%3CP%3EAmi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2746384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2746727%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20and%20Delete%20a%20Link%20in%20an%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746727%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154608%22%20target%3D%22_blank%22%3E%40AJFBlog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EFind%20links%20(external%20references)%20in%20a%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3ELinking%20to%20other%20workbooks%20is%20a%20very%20common%20task%20in%20Excel%2C%20but%20sometimes%20you%20might%20find%20yourself%20with%20a%20workbook%20that%20has%20links%20you%20can%E2%80%99t%20find%20even%20though%20Excel%20tells%20you%20they%20exist.%20There%20is%20no%20automatic%20way%20to%20find%20all%20external%20references%20that%20are%20used%20in%20a%20workbook%2C%20however%2C%20there%20are%20several%20manual%20methods%20you%20can%20use%20to%20find%20them%20in%20this%20upper%20Link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EWas%20the%20answer%20useful%3F%20Mark%20them%20as%20helpful!%3C%2FP%3E%3CP%3EThis%20will%20help%20all%20forum%20participants.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2746799%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Find%20and%20Delete%20a%20Link%20in%20an%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154608%22%20target%3D%22_blank%22%3E%40AJFBlog%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20approach%20is%20using%20vba%20to%20remove%20broken%20links%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3ESub%20BreakLinks()%0A%20%20%20%20Dim%20wb%20As%20Workbook%0A%20%20%20%20Set%20wb%20%3D%20Application.ActiveWorkbook%0A%20%20%20%20If%20Not%20IsEmpty(wb.LinkSources(xlExcelLinks))%20Then%0A%20%20%20%20%20%20%20%20For%20Each%20link%20In%20wb.LinkSources(xlExcelLinks)%0A%20%20%20%20%20%20%20%20%20%20%20%20wb.BreakLink%20link%2C%20xlLinkTypeExcelLinks%0A%20%20%20%20%20%20%20%20Next%20link%0A%20%20%20%20End%20If%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, My Excel Indicates It cannot update a link when I open it.  I cant see any link in the Data links, so not sure where to find and delete the link.  

 

The message says: 

We cant connect to "https://LOCALS~1/Temp/DOCUME~1/........ and ends with .xls

 

Please help,

Ami 

 

5 Replies

@AJFBlog 

 

Find links (external references) in a workbook

Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. There is no automatic way to find all external references that are used in a workbook, however, there are several manual methods you can use to find them in this upper Link.

 

NikolinoDE

Was the answer useful? Mark them as helpful!

This will help all forum participants.

@AJFBlog 

Another approach is using vba to remove broken links

Sub BreakLinks()
    Dim wb As Workbook
    Set wb = Application.ActiveWorkbook
    If Not IsEmpty(wb.LinkSources(xlExcelLinks)) Then
        For Each link In wb.LinkSources(xlExcelLinks)
            wb.BreakLink link, xlLinkTypeExcelLinks
        Next link
    End If
End Sub
Thanks. I’ve tried all those things but can’t seem to locate it. Seems that this is a link to a webpage, but I don’t see any hyper links.

Did you try the code posted above?

Maybe it can help you.

@AJFBlog 

If none of this worked, try Inquire and make a Workbook Analysis.


Analyze a workbook with Spreadsheet Inquire

 

Hope I was able to help you with this info.

 

*Ps. If this not help too, then send the file (without sensitive data).

 

Nikolino

I know I don't know anything (Socrates)