08-10-2017 03:38 AM
08-10-2017 03:38 AM
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.
08-10-2017 03:46 AM
Please check this https://techcommunity.microsoft.com/t5/Excel/Remove-link/m-p/92442 if it helps
08-16-2017 05:58 AM
- 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...
04-26-2018 12:14 PM
04-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.
04-30-2018 08:49 AM
05-01-2018 08:38 AM
05-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.
05-02-2018 12:30 AM
05-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?
05-02-2018 07:34 AM
11-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.
11-19-2018 12:57 AM
11-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 :)
11-19-2018 01:45 AM