SOLVED

Names with error - unable to delete

%3CLINGO-SUB%20id%3D%22lingo-sub-2245571%22%20slang%3D%22en-US%22%3ENames%20with%20error%20-%20unable%20to%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245571%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20a%20heavy%20worksheet%2C%20made%20from%20pieces%20of%20other%20old%20worksheets%2C%20that%20is%20very%20important%20for%20me.%20However%2C%20after%20a%20couple%20of%20months%2C%20I%20noticed%20that%20some%20names%20have%20lost%20their%20references%2C%20and%20now%20I'm%20unable%20to%20delete%20them%20(they%20became%20grey%20when%20selected%2C%20and%20no%20option%20to%20delete%20is%20available).%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20clean%20these%20%22ghost%22%20names%3F%20-%20Beyond%20the%20fact%20that%20they%20are%20polluting%20my%20work%2C%20somehow%20their%20references%20have%20survived%2C%20and%20every%20time%20I%20open%20the%20worksheet%2C%20it%20takes%20time%20trying%20to%20find%20the%20links.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20any%20formula%20or%20application%20actually%20using%20these%20names.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SandroD1972_0-1617141920513.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268377i484A8E4405F23F74%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SandroD1972_0-1617141920513.png%22%20alt%3D%22SandroD1972_0-1617141920513.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2245571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2245946%22%20slang%3D%22en-US%22%3ERe%3A%20Names%20with%20error%20-%20unable%20to%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245946%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1013073%22%20target%3D%22_blank%22%3E%40SandroD1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FOfficeMarketPlaceNM-EN.asp%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EName%20Manager%3C%2FA%3E%26nbsp%3Bfrom%26nbsp%3B%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2246469%22%20slang%3D%22en-US%22%3ERe%3A%20Names%20with%20error%20-%20unable%20to%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246469%22%20slang%3D%22en-US%22%3EI'm%20wondering%2C%20perhaps%20your%20file%20has%20either%20worksheet%20or%20workbook%20protection%20set%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2264424%22%20slang%3D%22en-US%22%3ERe%3A%20Names%20with%20error%20-%20unable%20to%20delete%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264424%22%20slang%3D%22en-US%22%3EYes%2C%20I%20noticed%20the%20references%20are%20attached%20with%20one%20specific%20tab%20that%20I%20received%20outside%20my%20organization%2C%20and%20it%20was%20protected.%20So%2C%20mystery%20solved.%20Thanks%20for%20your%20insight.%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

I'm working on a heavy worksheet, made from pieces of other old worksheets, that is very important for me. However, after a couple of months, I noticed that some names have lost their references, and now I'm unable to delete them (they became grey when selected, and no option to delete is available). 

Does anyone know how to clean these "ghost" names? 

I don't have any formula or application actually using these names. 

SandroD1972_0-1617141920513.png

 

 

4 Replies
best response confirmed by SandroD1972 (New Contributor)
Solution
I'm wondering, perhaps your file has either worksheet or workbook protection set?
Yes, I noticed the references are attached with one specific tab that I received outside my organization, and it was protected. So, mystery solved. Thanks for your insight.
Thanks for sharing it. I visited the site you recommended, and I'm impressed with the number of tools that Mr. Pieterse has developed. Thanks!