Unable to delete Named Ranges from Name Manager in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1442717%22%20slang%3D%22en-US%22%3EUnable%20to%20delete%20Named%20Ranges%20from%20Name%20Manager%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442717%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20delete%20several%20Named%20Ranges%20from%20my%20Name%20Manager%2C%20because%20I%20suspect%20they%20are%20slowing%20down%20my%20file.%20The%20Named%20Ranges%20originally%20stem%20from%20other%20files%2C%20but%20these%20files%20no%20longer%20exist.%20The%20issue%20I%20am%20experiencing%20is%20that%20I%20can%20not%20press%20the%20'delete'%20button.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Aantekening%202020-06-05%20141338.png%22%20style%3D%22width%3A%20553px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196702iF7ADBDF8409C7844%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Aantekening%202020-06-05%20141338.png%22%20alt%3D%22Aantekening%202020-06-05%20141338.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20encountered%20this%20problem%20before%20and%2For%20do%20you%20have%20a%20suggestion%20for%20a%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1442717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442755%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20delete%20Named%20Ranges%20from%20Name%20Manager%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690102%22%20target%3D%22_blank%22%3E%40mekremer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDid%20you%20try%20these%20topics%3F%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fcannot-delete-named-range%2Facaf9b4e-993b-46e1-a741-9a5c09337a6c%3Fpage%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fcannot-delete-named-range%2Facaf9b4e-993b-46e1-a741-9a5c09337a6c%3Fpage%3D1%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442777%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20delete%20Named%20Ranges%20from%20Name%20Manager%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442777%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20suggestion.%20I%20tried%20those%20solutions%2C%20but%20did%20not%20find%20something%20that%20works.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20sheets%20that%20it%20refered%20to%20were%20not%20protected.%20I%20tried%20deleting%20the%20files%20to%20see%20if%20it%20would%20solve%20anything%2C%20which%20also%20did%20not%20solve%20the%20issue.%20I%20did%20manage%20to%20delete%20some%20names%20using%20VBA%2C%20but%20this%20does%20not%20work%20for%20the%20duplicate%20names%20in%20the%20list%20(and%20somehow%20there%20are%20many).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442877%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20delete%20Named%20Ranges%20from%20Name%20Manager%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690102%22%20target%3D%22_blank%22%3E%40mekremer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2FOfficeMarketPlaceNM-EN.asp%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETry%20the%20Name%20Manager%20add%20in.%20It%20worked%20for%20me.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447892%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20delete%20Named%20Ranges%20from%20Name%20Manager%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3BThanks%2C%20that%20solved%20my%20issue!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%20it%20did%20not%20improve%20performance%20much%2C%20but%20hey%2C%20one%20step%20at%20a%20time%20right%20%3CLI-EMOJI%20id%3D%22lia_winking-face%22%20title%3D%22%3Awinking_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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. 

 

Aantekening 2020-06-05 141338.png

 

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

4 Replies
Highlighted
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).
Highlighted

@Detlef Lewin Thanks, that solved my issue!! 

 

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