Forum Discussion
Remove link
Hi all,
In a Excel book, I have a not removable link to a not exsisting xlsm file. I tried to remove it with "Break Link", but it doesn't work.
Some suggestions?
Thnx!
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.
12 Replies
- Anonymous
Hi Wouter,
- Place the cursor on the cell that has the link.
- Press F9 key
- Press Enter key
Hope that helps..
- Moyna GoodCopper Contributor
I wouter, I can't find the cell with the link, any idea how I find it please?
- wouter.scheerlinckCopper Contributor
- Anonymous
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