Apr 13 2021 09:41 AM
PC Windows 10 Ed / MS Office 365
Have passed down sheet with drop down menu options. Column I is solicitor team member names which is extremely out of date. I have not used Name Mgr for dropdowns before and can not find a way to edit this list.
Any suggestions appreciated.
Apr 13 2021 09:52 AM
Solution
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.
Apr 13 2021 09:59 AM
Apr 13 2021 10:07 AM - edited Apr 13 2021 10:14 AM
@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.
Apr 13 2021 10:47 AM
Apr 13 2021 11:39 AM
Apr 13 2021 09:52 AM
Solution
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.