Excel Field Names That Cannot Be Deleted
GR
-
jfe470 -
jfe470 -
Hello,
I would like to delete a number of field names appearing in my "name manager" for which:
1/ The "value" column indicates either #REF or {...}.
2/ The "Refers to" column gives the value #REF.
3/ The "edit" and "delete" functions in the name manager are grayed out.
How can I delete them?
Thank you for your help.
I would like to delete a number of field names appearing in my "name manager" for which:
1/ The "value" column indicates either #REF or {...}.
2/ The "Refers to" column gives the value #REF.
3/ The "edit" and "delete" functions in the name manager are grayed out.
How can I delete them?
Thank you for your help.
5 answers
-
If it's in Excel 2007:
- go to the name manager (Tab "Formulas")
- note the value in the "Refers to" column of the name that cannot be deleted
- close the name manager
- go to the tab bearing the previously noted name
- remove the sheet protection (Tab "Review > Unprotect Sheet")
- return to the name manager
-> it should now be possible to delete the name
--
