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...
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.
