SOLVED
Home

Remove link

%3CLINGO-SUB%20id%3D%22lingo-sub-92442%22%20slang%3D%22en-US%22%3ERemove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92442%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20Excel%20book%2C%20I%20have%20a%20not%20removable%20link%20to%20a%20not%20exsisting%20xlsm%20file.%20I%20tried%20to%20remove%20it%20with%20%22Break%20Link%22%2C%20but%20it%20doesn't%20work.%3C%2FP%3E%3CP%3ESome%20suggestions%3F%3C%2FP%3E%3CP%3EThnx!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-92442%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-376855%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-376855%22%20slang%3D%22en-US%22%3EThanks%20Sergei%20for%20leading%20me%20right!%20I%20found%20my%20links%20in%20the%20named%20ranges.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-209267%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-209267%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wouter%2C%20I%20can't%20find%20the%20cell%20with%20the%20link%2C%20any%20idea%20how%20I%20find%20it%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-93293%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-93293%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wouter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENope%2C%20i'm%20not%20so%20familiar%20with%20Excel%20XML%20schema%2C%20sorry%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-93223%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-93223%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIndeed%2C%20I%20find%20the%20linked%20file%26nbsp%3Bname%20in%20one%20of%20the%20unzipped%20files%2C%20but%20can%20I%20trace%20the%20cell%20with%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-93011%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-93011%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wouter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20so%20good.%20Just%20in%20case%20for%20future%20-%20you%20may%20find%20the%20broken%20link%20in%20unziped%20Excel%20file%20(add%20.zip%20extension%20and%20unzip%20like%20archive)%2C%20depends%20on%20in%20which%20XML%20file%20the%20link%20is%20and%20what%20is%20about%20you%20may%20have%20a%20guess%20where%20is%20that%20link%20in%20Excel%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92944%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20clear%20all%20conditional%20formating%20in%20all%20sheets%2C%20save%20as%20and%20reopen%2C%20the%20link%20was%20gone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThnx!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92820%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92820%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wouter%2C%3C%2FP%3E%3CP%3ECan%20you%20try%20recalculating%20the%20entire%20workbook%20using%20the%20key%20combination%20%22CTRL%20%2B%20SHIFT%20%2B%20F9%22%20and%20then%20check%20to%20see%20if%20the%20link%20still%20shows%20up%20in%20the%20%22Edit%20Links%22%20dialogue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBalakrishna%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92680%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92680%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wouter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELinks%20could%20be%20in%20many%20places%20-%20named%20ranges%2C%20data%20validation%2C%20macros%2C%20conditional%20formatting%20rules.%20There%20are%20some%20third%20party%20utilities%20to%20find%20links.%20Never%20used%20them%2C%20thus%20can't%20recommend%2C%20google%20will%20help%2C%20for%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F953-excel-list-all-links.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F953-excel-list-all-links.html%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20Inquire%20in%20your%20veriosn%20of%20Excel%20you%20may%20start%20from%20it%20to%20analyse%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92552%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92552%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Balakrisna%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20part%20of%20the%20problem%2C%20I%20think.%20There%20are%20no%20cells%20links%20to%20this%20external%20file.%3C%2FP%3E%3CP%3EWhen%20I%20start%20a%20search%20with%20%22.xl%22%2C%20it%20gives%20no%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-92452%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-92452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Wouter%2C%3C%2FP%3E%3CUL%3E%3CLI%3EPlace%20the%20cursor%20on%20the%20cell%20that%20has%20the%20link.%3C%2FLI%3E%3CLI%3EPress%20F9%20key%3C%2FLI%3E%3CLI%3EPress%20Enter%20key%3C%2FLI%3E%3C%2FUL%3E%3CP%3EHope%20that%20helps..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-553973%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20issue%20and%20can't%20locate%20the%20link%20in%20the%20workbook%20anywhere.%20It's%20not%20showing%20in%20Name%20Manager%20and%20when%20I%20try%20to%20break%20the%20link%20it%20doesn't%20work.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8600%22%20target%3D%22_blank%22%3E%40Balakrishna%20Sappa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555179%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555179%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339302%22%20target%3D%22_blank%22%3E%40Arielle_B%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20the%20below%3A%3CBR%20%2F%3E1.%20Place%20the%20cursor%20on%20the%20cell%20that%20has%20the%20link.%26nbsp%3BPress%20F9%20key.%20Press%20Enter%20key%3C%2FP%3E%3CP%3E2.%26nbsp%3B%20Search%20in%20Formulas%20for%20%22.xl%22%20or%20%22%5B%22%3C%2FP%3E%3CP%3E3.%20Check%20in%20Name%20Manager.%20This%20anyhow%20you%20confirmed.%3C%2FP%3E%3CP%3E4.%20check%20the%20above%20in%20any%20Hidden%20and%20VeryHidden%20worksheets.%3C%2FP%3E%3CP%3E5.%20Check%20Cells%20having%20Conditional%20Formatting%3C%2FP%3E%3CP%3E6.%20Check%20Cells%20having%20Data%20Validation%3CBR%20%2F%3E7.%20Change%20file%20extension%20to%20.zip.%20Extract%20the%20zip.%20Search%20for%20reference%20in%20.xml%20files...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6.....%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6......%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6.....%E2%80%A6%E2%80%A6...%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6............%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6......%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6...%E2%80%A6%E2%80%A6%E2%80%A6...%E2%80%A6...%E2%80%A6.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................%3C%2FP%3E%3C%2FLINGO-BODY%3E
wouter.scheerlinck
New Contributor

Hi all,

 

In a Excel book, I have a not removable link to a not exsisting xlsm file. I tried to remove it with "Break Link", but it doesn't work.

Some suggestions?

Thnx!

12 Replies

Hi Wouter,

  • Place the cursor on the cell that has the link.
  • Press F9 key
  • Press Enter key

Hope that helps..

Hi Balakrisna,

 

That's part of the problem, I think. There are no cells links to this external file.

When I start a search with ".xl", it gives no result.

Solution

Hi Wouter,

 

Links could be in many places - named ranges, data validation, macros, conditional formatting rules. There are some third party utilities to find links. Never used them, thus can't recommend, google will help, for example https://www.extendoffice.com/documents/excel/953-excel-list-all-links.html.

 

If you have Inquire in your veriosn of Excel you may start from it to analyse workbook.

Hi Wouter,

Can you try recalculating the entire workbook using the key combination "CTRL + SHIFT + F9" and then check to see if the link still shows up in the "Edit Links" dialogue.

 

Thanks,

Balakrishna

Hi Sergei,

 

After clear all conditional formating in all sheets, save as and reopen, the link was gone!

 

Thnx!

Hi Wouter,

 

So far so good. Just in case for future - you may find the broken link in unziped Excel file (add .zip extension and unzip like archive), depends on in which XML file the link is and what is about you may have a guess where is that link in Excel file.

Hey Sergei,

 

Indeed, I find the linked file name in one of the unzipped files, but can I trace the cell with it?

 

 

Hi Wouter,

 

Nope, i'm not so familiar with Excel XML schema, sorry

I wouter, I can't find the cell with the link, any idea how I find it please?

Thanks Sergei for leading me right! I found my links in the named ranges.

I am having the same issue and can't locate the link in the workbook anywhere. It's not showing in Name Manager and when I try to break the link it doesn't work. @Deleted 

@Arielle_B 

Try the below:
1. Place the cursor on the cell that has the link. Press F9 key. Press Enter key

2.  Search in Formulas for ".xl" or "["

3. Check in Name Manager. This anyhow you confirmed.

4. check the above in any Hidden and VeryHidden worksheets.

5. Check Cells having Conditional Formatting

6. Check Cells having Data Validation
7. Change file extension to .zip. Extract the zip. Search for reference in .xml files...…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….....……………………………………………………………………………………………………………………………………………………………………………………………………………………......……………………………………………………………………………………………….....……...…...…………...………………………………...……...…………............………………...………...…......……………...…...…………………………...…………...……...………...…...….............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................