Forum Discussion
ngibson5
Sep 05, 2024Copper Contributor
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, ...
- Sep 05, 2024It 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
Patrick2788
Sep 05, 2024Silver Contributor
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
https://support.microsoft.com/en-us/office/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77