Unable to delete Named Ranges from Name Manager in Excel

[mekremer]

I am trying to delete several Named Ranges from my Name Manager, because I suspect they are slowing down my file. The Named Ranges originally stem from other files, but these files no longer exist. The issue I am experiencing is that I can not press the 'delete' button. 

Has anyone encountered this problem before and/or do you have a suggestion for a solution?

[#2]

@mekremer 

Did you try these topics?

https://answers.microsoft.com/en-us/msoffice/forum/all/cannot-delete-named-range/acaf9b4e-993b-46e1-...

[#3]

Thanks for your suggestion. I tried those solutions, but did not find something that works.

The sheets that it refered to were not protected. I tried deleting the files to see if it would solve anything, which also did not solve the issue. I did manage to delete some names using VBA, but this does not work for the duplicate names in the list (and somehow there are many).

[#4]

@mekremer 

Try the Name Manager add in. It worked for me. 

[#5]

@Detlef Lewin Thanks, that solved my issue!! 

Unfortunately it did not improve performance much, but hey, one step at a time right

[#6]

@mekremer converting Tables to Ranges fixed it for me (then you can delete, etc.).