How can I edit the existing name manager. My sheet is not protected with password. Still the edit and delete buttons are greyed out
Thank you
How can I edit the existing name manager. My sheet is not protected with password. Still the edit and delete buttons are greyed out
Thank you
does this link help?
https://www.exceldemy.com/excel-name...te-greyed-out/
or this one...
https://www.excelforum.com/excel-gen...e-manager.html
if not you might need to upload the workbook
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
hi, mls_newbee
It seems like there might be hidden or protected sheets linked to the Name Manager. Ensure all sheets are unprotected and there are no external references in your workbook. If the problem persists, try transferring the data to a new workbook to see if that resolves the issue.
Thank you both. I could not resolve this issue. There is no protected sheet in my workbook and certainly it has references from one sheet to other.
I just created new lists and used them as drop downs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks