Forum Discussion
Data Validation Drop Down List not Saving
I create a Data Validation Drop Down list in Excel, and it works while I have the workbook open, but if I save and close the Excel 97-2003 Worksheet file, then re-open the file, it does not work. Whe...
From your text I cannot infer which version of Excel you are dealing with, knowing the operating system would also be a plus for a proposed solution.
Nevertheless, here ... some information about it.
- First define a name for the area
- and then use this name as the scope
- and then use this name in source / refers to
drop-down menu not visible
Thank you for your understanding and patience
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here