Forum Discussion
how to edit inherited name manager menu in spreadsheet?
Whoever created that workbook was too clever by half. The data validation list that populates that drop down was in a separate hidden sheet. Moreover, the sheet is password protected. I've unhidden the sheets--there were two hidden--but don't know the password(s). Once you've gotten the password(s), you will be able to edit the list. Short of that, at least you can see where the list is....and maybe start over with another sheet.
JoAStro There are two hidden sheets in your workbook. Both are protected though. Have unhidden them for you. Sheet2 hold the lists for the dropdowns. Sheet3 mostly has errors. Both are protected and require a password to change them.
Created a Sheet4 for you containing the dropdown listings that you can edit, but you'd have to link them again yourself. See attached.
Edit: Didn't see the previous posts before I posted mine.
So appreciate the help.