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!

excel

SergeiBaklan
Aug 02, 2017
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.

wouter.scheerlinck

Copper Contributor

Aug 02, 2017

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.

SergeiBaklan

Diamond Contributor

Aug 02, 2017

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.

Forum Discussion

Remove link