excel 2016 keeps asking to update the external link

[tranxuantu]

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.

Br.,

TXT

[#2]

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