Forum Discussion
Solved
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.
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?