As lenze so rightly says, you will probably need to do a find and replace on the formulas first. I can help you delete all the ranges at once though, with this bit of vb code:
Sub DeleteNamedRanges()
For n = 1 To ActiveWorkbook.Names.Count
ActiveWorkbook.Names(1).Delete
Next n
End Sub