Jump to hyperlink

[davidzan]

When attempting to use a hyperlink (Excel 2010), I get the following message:

How can this be corrected?

 

[Joe4]

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?

 

[davidzan]

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?

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!!

 

[Joe4]

Did you try this?

Remove or turn off hyperlinks - Microsoft Support

Remove one or more hyperlinks from a page, or turn off automatic hyperlink creation as you type.

support.microsoft.com

 

[davidzan]

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?

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.

 

[Joe4]

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 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.

 

[davidzan]

I 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.

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 box

 

[Joe4]

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.

 

[davidzan]

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.

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!!