Forum Discussion
how to remove external links from excel
Hi Kacper,
Please check this https://techcommunity.microsoft.com/t5/Excel/Remove-link/m-p/92442 if it helps
Hello,
I followed up with https://techcommunity.microsoft.com/t5/Excel/Remove-link/m-p/92442 and https://www.extendoffice.com/documents/excel/953-excel-list-all-links.html
- installed Kutools, however I can not remove external links with that tool. I cnan ot find any links with search option " [ ".
Extarnal links still are there and when I open workbook, it every time asks me to update those links, which is very annoying and does not look proffessionals to clients...
- JKPieterseAug 16, 2017Silver Contributor
The industry standard tool for links can be found here: FindLink
- XLismylifeSep 20, 2019Copper Contributor
JKPieterse This is awesome! I struggled with mine for 2 days and never suspected Data Validation as the culprit. Thank you so much!!
- JKPieterseSep 20, 2019Silver ContributorYou're welcome.
- k lApr 26, 2018Copper ContributorI have the same problem. There is a link to an external file that the break-link command will not break. I have been through every thread I can find on the subject, including the FindLink utility, but to no avail.
It seems that there are some kinds of links that, once created, cannot be removed.- Kacper ModzelewskiApr 27, 2018Copper Contributor
Yeh, unfortunately ;/ I had to recreate all excel files .. no solution to that so far ..