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 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,
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.
Hi Sergei,
After clear all conditional formating in all sheets, save as and reopen, the link was gone!
Thnx!
Hi Wouter,
So far so good. Just in case for future - you may find the broken link in unziped Excel file (add .zip extension and unzip like archive), depends on in which XML file the link is and what is about you may have a guess where is that link in Excel file.
Hey Sergei,
Indeed, I find the linked file name in one of the unzipped files, but can I trace the cell with it?
