Can’t Break External Links (NO MATTER WHAT)

[petiteshiraz]

I have three references to external links that I am trying to kill, but with no result. I’ve tried finding the external link to remove it via the standard methods described in the link below, but with no result.
https://support.office.com/en-au/ar...eference-89049c04-cbf3-4112-9221-849454341f1a

I’ve tried several times to break the links in the “Edit Links” tool. I see each source link listed, but nothing happens when I try to break the link.

Any ideas on how I can do this?

 

[Ron Coderre]

I've seen workbooks with hidden names that reference other workbooks.

Try running this little macro:

• ALT+F11…to open the Visual Basic Editor
• Right-click on your workbook's name in the VBA - Projects window
...Select: Insert Module
• Copy the below VBA code and paste it into that module:

Public Sub MakeRangeNamesVisible()
Dim wbk As Workbook
Dim nmName As Name
Set wbk = ActiveWorkbook
For Each nmName In wbk.Names
    nmName.Visible = True
Next nmName
End Sub

Then check your names:
Formula.Name Manager

Does that help

 

[petiteshiraz]

Hi Ron.

I was able to follow your instruction up to the point where you say:

"Then check your names:
Formula.Name Manager"

How/where do I check names?

 

[petiteshiraz]

By the way, I had already checked the "Name Manager" tool in the FORMULAS toolbar. I went through and did not find anything referring to external links there.

 

[Ron Coderre]

Yes...The name manager is what I wanted you to check.
If there were hidden names, you wouldn't have seen them until after running the macro I posted.
If you still do not see any references to other workbooks, then hidden range names is not the issue.

Have you already checked for hidden worksheets?

 

[SpillerBD]

Check Data\Connections\Connections
Anything there?