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...
SergeiBaklan
Jun 05, 2020Diamond Contributor
Did you try these topics?
- mekremerJun 05, 2020Copper ContributorThanks 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).- Detlef_LewinJun 05, 2020Silver Contributor
- mekremerJun 08, 2020Copper Contributor
Detlef_Lewin Thanks, that solved my issue!!
Unfortunately it did not improve performance much, but hey, one step at a time right 😉