Forum Discussion

omatthie's avatar
omatthie
Copper Contributor
Jul 27, 2020
Solved

Excel - breaking links to another file

Hi – I am struggling to remove 1 of multiple links. Have tried all advises how to break a link but it doesn't help. Anyone who have an idea – is there a “safe” add in ? Kind regards OCM
excel
  • TheAntony's avatar
    TheAntony
    Aug 01, 2020

    omatthie , Try this add-in:

     

    https://manville.org.uk/software/findlink.htm

TheAntony's avatar
TheAntony
Iron Contributor
Aug 01, 2020

omatthie , Try this add-in:

 

https://manville.org.uk/software/findlink.htm

omatthie's avatar
omatthie
Copper Contributor
Aug 04, 2020

TheAntony 

Fantastic – Your suggested add in solved my problem.

The problem was that I had “hidden” the link in a Data validation, hence there was no link reference in the cell.  However, your add in pointed out the correct cell

Thank you

  • LaurenShields's avatar
    LaurenShields
    Copper Contributor
    Sep 23, 2020
    This is the best answer!!!