Forum Discussion
excel 2016 keeps asking to update the external link
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
1 Reply
- JMB17Bronze ContributorI'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