Forum Discussion
kiwi_10
Jul 20, 2023Copper Contributor
Unable to delete old defind names in name manager
Hi guys! Does some know if there is a way to delete old defind names while the options is greyed out? I used defined names for several calculations during my studies. Now I changed my laptop ...
mathetes
Jul 20, 2023Gold Contributor
Faced with that a few times in the past, my recollection is that I ultimately had to resort to copying and using Paste Special to create a duplicate of the layouts of the spreadsheet(s) in question, along with any data constants, but without the named references; then delete the sheets that contained the named ranges and start over.