How to get rid of hidden external link

[dan52]

I have a file with an external link that I can't locate, break or delete. In fact, I isolated the link to one particular tab, deleted all of the other tabs, and then deleted all of the content on the "corrupted" tab and it's still there. I'd love to post the file in case someone knows how to find the problem, but I don't know how to attach a file to a question. Any suggestions?? Dan

 

[shg]

Links can hide in a lot of places.

You could put the workbook on box.net and post a link.

 

[dan52]

Here's a link to the file on Google Drive:
https://drive.google.com/open?id=1b08v4-maLGeMCQeRFGHFbR1KJqK7l44f

If you download it and open it in excel, it should have a link to an external file at "K:\Documents and Settings\gina.g.smith\Deskt...\DONBIS Recon" that I can't find, delete, open, change or break. It came from a much more complex workbook, but I deleted everything else one step at a time trying to find the location of the problem. Can anyone help me fix this? Thanks.

 

[shg]

Run this:

Sub Unhide()
  Dim oNam         As Name
  For Each oNam In ActiveWorkbook.Names
    oNam.Visible = True
  Next
End Sub

Then look at that big list of names in Name Manager. Delete 'em.

The delete the data validation in C4 and P3.

 

[dan52]

Thanks shg, that did the trick. How did you find the cells with data validation??

 

[shg]

Ctrl+G (Go To) > Special > Data Validation

 

[dan52]

Thanks! We've worked around this problem for weeks. I should have come to the BB sooner. Really appreciate your help.

 

[shg]

You're welcome.