Data Validation Drop Down List not Saving

Occasional Visitor

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. When I click the down arrow nothing happens. It is like it does not save the connection to the table. Anyone know why this is happening?

2 Replies



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.



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



Most probably compatibility issues. As I remember in 97-2003 data for data validation list can't be in another sheet, perhaps something else. It works as it is now at least from 2010.