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.
Hey Sergei,
Indeed, I find the linked file name in one of the unzipped files, but can I trace the cell with it?
Hi Wouter,
Nope, i'm not so familiar with Excel XML schema, sorry