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...
I am having the same problem. I made a drop-down list in Excel (Office 365) before and it worked as intended. Now, for some unknown reason, it doesn't anymore. It shows the arrow but I can't click it to reveal the list.
I noticed that when you open the file and close it back. It will ask you if you want to save the changes despite just opening it. It seems like it has something to do with the data validation for the drop-down list.
I noticed that when you open the file and close it back. It will ask you if you want to save the changes despite just opening it. It seems like it has something to do with the data validation for the drop-down list.