Forum Discussion
Remove link
Hi Wouter,
Links could be in many places - named ranges, data validation, macros, conditional formatting rules. There are some third party utilities to find links. Never used them, thus can't recommend, google will help, for example https://www.extendoffice.com/documents/excel/953-excel-list-all-links.html.
If you have Inquire in your veriosn of Excel you may start from it to analyse workbook.
Hi Wouter,
- Place the cursor on the cell that has the link.
- Press F9 key
- Press Enter key
Hope that helps..
I wouter, I can't find the cell with the link, any idea how I find it please?
Hi Balakrisna,
That's part of the problem, I think. There are no cells links to this external file.
When I start a search with ".xl", it gives no result.
Hi Wouter,
Can you try recalculating the entire workbook using the key combination "CTRL + SHIFT + F9" and then check to see if the link still shows up in the "Edit Links" dialogue.
Thanks,
Balakrishna
I am having the same issue and can't locate the link in the workbook anywhere. It's not showing in Name Manager and when I try to break the link it doesn't work. Deleted
Hi Wouter,
Links could be in many places - named ranges, data validation, macros, conditional formatting rules. There are some third party utilities to find links. Never used them, thus can't recommend, google will help, for example https://www.extendoffice.com/documents/excel/953-excel-list-all-links.html.
If you have Inquire in your veriosn of Excel you may start from it to analyse workbook.
- Thanks Sergei for leading me right! I found my links in the named ranges.
