Hidden links? How to get rid of?

Welcome.
The attached file contains probably some hidden links that appear only in August when we do even one "normal" link to another file. I tried with a macro that shows all of the links it contains the file, but it still does not show me the problem. I also attach screenshots that show an attempt to connect to external files (hidden links). I do not know how to remove them. Has anyone an idea what it could be and how to get rid of?

When you open the excel file, press update, after a long pause jump out messages about trying to connect to an external file. What is it and how to remove?

Thanks in advance...

Sixthsense Thanks for your try, but this is only "hiding" (turn off) the problem .

I would like to remove links from the file (some files have this problem, are "infected" by links), most are good. This is not a situation in which changing Excel from 2003 to 2010 made all of files to show an external links, when trying to update. Only some of files, are "infected", probably modified from one file at the beginning.

But thank you for your attempt to solve the topic...

No, it's not that simple.

Please check on your own: remove links from the file, save, exit and re-enter. It'll be fine. But do some new link from a file, no matter what. Make a new excel file and link to one cell. Save and close the file "abc123", then open it - hidden links will appear and re-attempt to connect with "strange" links ... It is as if the file was saved somewhere further, that if it appears in any connection, it tries to establish connection with the other, hidden? If I do new different excel file and connecting it to the next file will be ok, no hidden links.

Originally Posted by Izandol

There are many (110) hidden names in this file. Please run this code:

Please Login or Register  to view this content.

then examine results in Name Manager on Formulas tab.

YES Thank you for solving the problem :D finally got rid of that, thanks to you. Earlier I tried to remove the name using code:

Dim n As Name
On Error Resume Next
For Each n In ActiveWorkbook.Names
n.Delete
Next n


But it did not give the expected result.

Can I have an additional question. How should look macro code that immediately unhidden and delete names without manual interference with the manager names.

Sub unhideNames()
Dim nm As Name
For Each nm In ActiveWorkbook.Names
nm.Visible = True
Next nm

On Error Resume Next
For Each nm In ActiveWorkbook.Names
nm.Delete
Next nm

End Sub

and works