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.
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.
I've always had my data options on the same sheet in hidden/protected cells. Guess I'll be starting over. Thank you for the prompt response.
- A suggestion for you. I think the idea of having a separate sheet for lists and tables used for background reference is fine; I usually do that, and I'll call that sheet something like "Business Tables" or "Background Tables" to designate its purpose. But unless it needs to be hidden from other users, I'd keep it visible and just put a strong warning on it not to mess with it. Or Password protect it, but make sure the password is accessible and mainly used to keep it from accidental change. Obviously there are situations where utmost security is needed; this one you're dealing with doesn't seem like one of those situations; instead--and why I said the original user was "too clever by half"--is that it's protection that ends up shooting somebody in the foot, actually interfering with the functionality it was meant to provide.