Macro to Delete #REF range names
This macro will enable you to delete named ranges with #REF error in it.
'Macro Purpose: To delete any named range with a "#REF!" error in it
Dim nm As Name
For Each nm In ActiveWorkbook.Names
If InStr(1, nm.RefersTo, "#REF!") > 0 Then nm.Delete