Hidden links, source of which you will not find?

[YaroslavZ]

Thank you for taking a look.

I have a pretty simple file now that was built on a basis of an old complex file with a lot of links. In this testing file, Alpha (link) there is only 1 value, which refers via formula to 1 value of another workbook. The second workbook (Beta) (link) is completely new and can be any book you can create. I just added there one value.

Issue: when I'm opening workbook Alpha, I have a lot of popups that appear after the button in "Update links" window was clicked, or when I trigger "Enable Content". Popups like this (screenshot first and second) with links to other strange old workbooks and with old paths. I can't understand where should I start searching for reasons of this if I already broke all links in the workbook Alpha, which were there, cleaned up all macro were contained, and have only one link to a fresh workbook Beta (which have no connection with links you can see in popups).

 

[YaroslavZ]

It really makes me annoyed to have all of this on any "Enable content" click

 

[sandy666]

check for Data Validation if any

 

[YaroslavZ]

check for Data Validation if any

Doesn't affect the issue, still exists

 

[Fluff]

Check the name manager for external links

 

[sandy666]

check Ctrl+F3 (Name Manager)

 

[YaroslavZ]

check Ctrl+F3 (Name Manager)
View attachment 22873

All of them are mine, and have no connections to other sources. Deleting of them change nothing.

 

[sandy666]

I found only one link

and i am not getting any prompt to another workbook

I think would be good if you will do that with brand new workbook

 

[Fluff]

When I deleted those names, I got no pop-ups.

 

[YaroslavZ]

Found it out by myself - I've deleted hidden names via Document Checker: