Forum Discussion
workbook links vs edit links
Hello I have one file, which has inside it hidden links to some workbooks, i discovered this through the "inspect file" The issue is that in my excel 365, in Data tab i have a tab called "workbo...
There is an important difference between how "old" Excel reported links and how the new workbook links pane works. The old Edit links dialog ignored links in range names which are not in use, the new workbook links pane shows those as well. If you expand the links it finds, there should be a button to find the location. In such cases clicking the link that shows up will open Name Manager, which you can then use to scroll to the name in question and delete it.
Alternatively, download my Name Manager from here:
https://jkp-ads.com/excel-name-manager.asp and filter the names for "External".
Alternatively, download my Name Manager from here:
https://jkp-ads.com/excel-name-manager.asp and filter the names for "External".