I have a workbook bloated with named ranges but when I click name manager I am unable to open the name manager. When I go to run any of the VBA scripts to delete name ranges including hidden ranges, it gives me a runtime error & out of memory. I am able to run any other VBA script.

Is there a way to repair this workbook and clean out all of the unwanted name ranges?