It links to a file that has been deleted. When I try to break the link in the "Data" group, the linked file is not removed!!What exactly is it linking to?
Is it trying to link to a file in a restricted area?
Can you get to where it is trying to link to manually?
What exactly is it linking to?
Is it trying to link to a file in a restricted area?
Can you get to where it is trying to link to manually?
I am not understanding what you are trying to do.The file was created initially but has since been deleted. It is nowhere on my system now. I can "Break" the link but it still remains in the Edit Link Box and upon opening the worksheet, i get the link error message I attached am image of the file in question.
I don't want the link. That's my problem. There are no cells referencing the link. The message says Link can't be found but I am unable to delete the link in the Data > Edit Links dialog boxI am not understanding what you are trying to do.
Do you want the links or don't you?
If you want to keep them, then correct the link.
If you do not want it anymore, then delete all cells referencing that link.
Thanks so much for your time. I'll try your suggestions. If I can't find an answer, I'll check the box "Don't display the alert and update Links" so as not to get the message!!Take a look at this post here, which shows a few different ways to locate the links.
Searching for external links in excel workbook
I found there is a link to helping with this already (see below) however when following the same process it just says "We couldn't find what you were..techcommunity.microsoft.com
You may also want to check the Name Manager, to see maybe if they are referenced there.