Aug 10 2017 03:38 AM
hello
Please help me with following task - I try to remove external links from excel:
Data==>Edit Links==>break link
It does not work - still I have that external links in the list. Even I close and open excel file - still have it.
Aug 10 2017 03:46 AM
Hi Kacper,
Please check this https://techcommunity.microsoft.com/t5/Excel/Remove-link/m-p/92442 if it helps
Aug 16 2017 05:58 AM
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...
Apr 26 2018 12:14 PM
Apr 27 2018 06:05 AM
Yeh, unfortunately ;/ I had to recreate all excel files .. no solution to that so far ..
Apr 28 2018 02:53 AM
Apr 28 2018 03:34 PM
Yes, I tried FindLink. but, it does not see the link. Though I can see the link destination listed in the "Edit link" . I tried the "break link" function, but it has no effect.
Apr 30 2018 08:49 AM
May 01 2018 08:38 AM
May 01 2018 01:20 PM
I just realized that I had failed to save the version, where I had isolated the data validation cell that had the external link. One of the challenges with saving so many versions, as I gradually deleted more and more.
May 02 2018 12:30 AM
May 02 2018 06:00 AM
Then perhaps the FindLink program is not working properly on my system. I have it installed as an add-in, and ran it on this file. I also have some Visual Basic that I use regularly, so I know macros are fully enabled.
Is there anything you know of that will prevent FindLink from working properly?
-Joe
May 02 2018 07:34 AM
Nov 17 2018 09:04 PM
I had the same problem. Break Links did nothing. In the end I saved the file in the 97-2003 version (which stripped out the links as they weren't supported) and then converted back.
Nov 19 2018 12:57 AM
Nov 19 2018 01:00 AM
Beats me. I had a link to another file which 'break links' wouldn't touch so I saved then back again and no more file link :)
Nov 19 2018 01:45 AM
Sep 20 2019 10:07 AM
@Jan Karel Pieterse This is awesome! I struggled with mine for 2 days and never suspected Data Validation as the culprit. Thank you so much!!