excel 2016 keeps asking to update the external link

%3CLINGO-SUB%20id%3D%22lingo-sub-2014772%22%20slang%3D%22en-US%22%3Eexcel%202016%20keeps%20asking%20to%20update%20the%20external%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014772%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esomeone%20faced%20this%20error%20and%20can%20support%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20excel%20file%20that%20keeps%20asking%20to%20update%20the%20external%20link%20when%20opening%20-%20i%20followed%20some%20guide%20on%20internet%20but%20i%20cannot%20remove%20this%20external%20link%3A%20%22Name%20Manager%22%20does%20not%20have%20any%20value%20while%20i%20see%20a%20value%20of%20extenal%20link%20when%20i%20click%20to%20%22edit%20Links%22%20in%20%22data%22%20section%20of%20Ribbon.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20problem%20caused%20from%20action%20of%20sender%2C%20she%20copied%20a%20whole%20sheet%20(of%20other%20excel%20file)%20to%20this%20sheet.%3C%2FP%3E%3CP%3EI%20dont%20need%20this%20link%20and%20want%20to%20remove%20it%20but%20i%20can%20not%20-%20Excel%20keeps%20asking%20to%20auto%20update%20when%20opening%20-%20i%20hate%20this%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%2C%20the%20workaround%20is%20%22Dont%20display%20and%20dont%20update...%22%20option%20in%20%22Startup%20Prompt%22%20of%20%22Edit%20Links%22%20windows.%20But%20i%20still%20want%20to%20remove%20this%20useless%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20alot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tranxuantu_0-1608865033402.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F242771i934A45F5A9E6B461%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tranxuantu_0-1608865033402.png%22%20alt%3D%22tranxuantu_0-1608865033402.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBr.%2C%3C%2FP%3E%3CP%3ETXT%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2014772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014789%22%20slang%3D%22en-US%22%3ERe%3A%20excel%202016%20keeps%20asking%20to%20update%20the%20external%20link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014789%22%20slang%3D%22en-US%22%3EI've%20always%20used%20this%20add-in%20to%20find%20links%20in%20my%20workbook.%20Personally%2C%20I%20just%20have%20it%20make%20a%20list%20instead%20of%20taking%20any%20automatic%20action%2C%20but%20if%20you%20do%20select%20an%20automatic%20action%20you%20should%20make%20sure%20you%20have%20a%20backup%20of%20your%20project.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

someone faced this error and can support me?

 

I have a excel file that keeps asking to update the external link when opening - i followed some guide on internet but i cannot remove this external link: "Name Manager" does not have any value while i see a value of extenal link when i click to "edit Links" in "data" section of Ribbon.

 

This problem caused from action of sender, she copied a whole sheet (of other excel file) to this sheet.

I dont need this link and want to remove it but i can not - Excel keeps asking to auto update when opening - i hate this one.

 

So far, the workaround is "Dont display and dont update..." option in "Startup Prompt" of "Edit Links" windows. But i still want to remove this useless link.

 

thanks alot.

 

tranxuantu_0-1608865033402.png

 

Br.,

TXT

 

 

 

 

 

 

1 Reply
I've always used this add-in to find links in my workbook. Personally, I just have it make a list instead of taking any automatic action, but if you do select an automatic action you should make sure you have a backup of your project.

https://www.manville.org.uk/software/findlink.htm