Go to File > Options > Customize Ribbon > Check Developer
Go to Visual Basic
Copy in below code and run
Sub ShowAllNames()
Dim n As Name
For Each n In ActiveWorkbook.Names
n.Visible = True
Next n
End Sub
Then go to Formulas tab and Name Manager and delete the references