Forum Discussion
mekremer
Jun 05, 2020Copper Contributor
Unable to delete Named Ranges from Name Manager in Excel
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. T...
mekremer
Jun 05, 2020Copper Contributor
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).
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).
Detlef_Lewin
Jun 05, 2020Silver Contributor