Forum Discussion
Solved
Name Manager won't allow editing or deleting range
Can anyone explain?
The Name Manager in my workbook shows a number of named ranges that cannot be deleted or edited (except for the name itself). The Workbook and sheet are unlocked, not protected, and I am not using any add-ins.
What else would prevent these ranges from being edited or deleted?
- It sounds like you have a few tables. You can convert them to ranges to remove those items from name manager:
https://support.microsoft.com/en-us/office/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77
1 Reply
- It sounds like you have a few tables. You can convert them to ranges to remove those items from name manager:
https://support.microsoft.com/en-us/office/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77