Hidden links, source of which you will not find?

YaroslavZ

New Member
Joined
Sep 22, 2020
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
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).
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

YaroslavZ

New Member
Joined
Sep 22, 2020
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
It really makes me annoyed to have all of this on any "Enable content" click
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,898
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Check the name manager for external links
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
check Ctrl+F3 (Name Manager)
nm.png
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
I found only one link
link.png

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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,898
Office Version
  1. 365
Platform
  1. Windows
When I deleted those names, I got no pop-ups.
 

YaroslavZ

New Member
Joined
Sep 22, 2020
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
Found it out by myself - I've deleted hidden names via Document Checker:

thumbnail.png
thumbnail (1).png
thumbnail (2).png
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,312
Members
414,052
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top