Forum Discussion
Solved
Names with error - unable to delete
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.
- I'm wondering, perhaps your file has either worksheet or workbook protection set?
4 Replies
- 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.
Try Name Manager from JKPieterse.
- 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!
