Can't Find Links and Can't Break Links

%3CLINGO-SUB%20id%3D%22lingo-sub-2930331%22%20slang%3D%22en-US%22%3ECan't%20Find%20Links%20and%20Can't%20Break%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930331%22%20slang%3D%22en-US%22%3E%3CP%3EAt%20work%20we%20have%20a%20shared%20file.%20When%20I%20open%20it%20I%20get%20this%20message%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22georgethemarshall_0-1636101861413.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324480i35B711FD3CD53D34%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22georgethemarshall_0-1636101861413.png%22%20alt%3D%22georgethemarshall_0-1636101861413.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThere%20shouldn't%20be%20any%20links%20and%20it's%20annoying%20getting%20the%20message%2C%20so%20I%20try%20to%20remove%20them%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22georgethemarshall_1-1636102000596.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324482iAF8A022003701BE4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22georgethemarshall_1-1636102000596.png%22%20alt%3D%22georgethemarshall_1-1636102000596.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHowever%20the%20option%20to%20break%20the%20links%20isn't%20available.%20I've%20even%20tried%20searching%20for%20the%20file%20name%20in%20the%20workbook%20formulae%20and%20found%20nothing%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22georgethemarshall_2-1636102089016.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324483iF2980B0E7D8B3129%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22georgethemarshall_2-1636102089016.png%22%20alt%3D%22georgethemarshall_2-1636102089016.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAny%20ideas%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2930331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2930500%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Find%20Links%20and%20Can't%20Break%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930500%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1208054%22%20target%3D%22_blank%22%3E%40georgethemarshall%3C%2FA%3E%26nbsp%3B!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20check%20the%20Name%20Manager%20%3F%20There%20is%20probably%20a%20named%20range%20which%20refers%20to%20a%20cell%20or%20a%20range%20in%20another%20workbook.%20When%20you%20try%20to%20find%20an%20external%20link%20with%20search%20function%2C%20it%20will%20look%20up%20only%20to%20values%2C%20formulas%2C%20notes%20and%20comments%20in%20a%20specific%20sheet%20or%20the%20whole%20workbook%2C%20but%20not%20in%20Name%20Manager.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%20%3A%3C%2FP%3E%3CP%3EI%20have%20a%20named%20range%20-%20%22WB2_rng_example%22%20-%20in%20my%20workbook%20which%20refers%20to%20a%20cell%20in%20another%20workbook%20-%20%22WB2_example.xlsx%22%20-%26nbsp%3B%20(sorry%20my%20Excel%20is%20in%20french)%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NicolasTld_0-1636105954700.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324489i39BDAA2A3D4103F6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NicolasTld_0-1636105954700.png%22%20alt%3D%22NicolasTld_0-1636105954700.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20I%20try%20to%20find%20the%20external%20link%20with%20search%20function%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NicolasTld_1-1636106079249.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324490iC0E130EC932A029E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NicolasTld_1-1636106079249.png%22%20alt%3D%22NicolasTld_1-1636106079249.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20have%20the%20following%20error%20message%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3Enb%20%3A%20in%20english%20%22Microsoft%20Excel%20canno't%20find%20the%20data%20you're%20searching%20for%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22NicolasTld_2-1636106110683.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324491i8817B0A7CBF4BFC9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22NicolasTld_2-1636106110683.png%22%20alt%3D%22NicolasTld_2-1636106110683.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20click%20on%20%22Formulas%22%20pane%2C%20then%20on%20%22Name%20Manager%22%20and%20sort%20by%20%22Refers%20to%22.%20You%20will%20probably%20find%20the%20external%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you%20don't%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20good%20day%20!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENicolas%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-2930527%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Find%20Links%20and%20Can't%20Break%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032856%22%20target%3D%22_blank%22%3E%40NicolasTld%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Nicolas%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%20I've%20found%20the%20name%20manager.%20It%20has%20one%20item%20in%20it%2C%20but%20I'm%20not%20sure%20what%20to%20do%20next.%20When%20I%20select%20it%20it%20doesn't%20give%20me%20the%20option%20to%20edit%20or%20delete%20it%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22georgethemarshall_0-1636106524698.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324492i40D1397FE397260B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22georgethemarshall_0-1636106524698.png%22%20alt%3D%22georgethemarshall_0-1636106524698.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EGeorge%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

At work we have a shared file. When I open it I get this message: 

georgethemarshall_0-1636101861413.png

There shouldn't be any links and it's annoying getting the message, so I try to remove them: 

georgethemarshall_1-1636102000596.png

However the option to break the links isn't available. I've even tried searching for the file name in the workbook formulae and found nothing:

georgethemarshall_2-1636102089016.png

Any ideas? 

 

Thank you

5 Replies

Hello @georgethemarshall !

 

Have you check the Name Manager ? There is probably a named range which refers to a cell or a range in another workbook. When you try to find an external link with search function, it will look up only to values, formulas, notes and comments in a specific sheet or the whole workbook, but not in Name Manager.

 

Here is an example :

I have a named range - "WB2_rng_example" - in my workbook which refers to a cell in another workbook - "WB2_example.xlsx" -  (sorry my Excel is in french) : 

NicolasTld_0-1636105954700.png

 

if I try to find the external link with search function 

NicolasTld_1-1636106079249.png

 

I will have the following error message : 

nb : in english "Microsoft Excel canno't find the data you're searching for"

NicolasTld_2-1636106110683.png

 

So, click on "Formulas" pane, then on "Name Manager" and sort by "Refers to". You will probably find the external link.

 

Please let me know if you don't

 

Have a good day !

 

Nicolas

 

 

@NicolasTld 

Hi Nicolas

Thank you for your help. I've found the name manager. It has one item in it, but I'm not sure what to do next. When I select it it doesn't give me the option to edit or delete it:

georgethemarshall_0-1636106524698.png

Thanks

George

This name range is simply a table in your own workbook (as you can see, Table4 is a table in "Open Direct Vacancies" worksheet, range A2:H62. So this not the external link you are looking for.

 

First of all, try again to find the external link in your workbook by searching for ".xl" (and not ".xlsm" for example as it could be a ".xlsx" workbook) in the workbook.

 

There are also other possibilities :
- Are there some buttons in your workbook with macros assigned to it ? If yes, click right on each button, then on "Assign a macro", and check if it doesn't refer to a macro in another macro as the example below

NicolasTld_0-1636108983474.png

- Are there graphs in your workbook ? If yes, check that it doesn't refer to data in another workbook

NicolasTld_1-1636109163868.png

 

- Last solution : Check all the conditional formatting in your workbook ("Home" pane, click on "Conditional formatting" > "Manager rules" and look at the rules (it could refers to another workbook)

NicolasTld_2-1636109246699.png

 

I hope that helps

 

Nicolas

 

From your screenshot, it says it's Table4 on Open Direct Vacancies so go take out that sheet (move it to a new workbook) and see if the workbook is ok without it. Then re-create it.