Hi

I would try this macro to delete any hyperlink
Sub DisplayName()
Dim n As Name
For Each n In ThisWorkbook.Names
With n
If MsgBox("Delete " & .Name & " ? " & vbCrLf & _
"Refers to " & .RefersTo, vbYesNo + vbQuestion) Then .Delete
End If
End Sub