I have created a column which has in-cell drop-down menu referring to another list. I used Data Validation to do this. It worked. but today when I opened up the workbook again, the dropdown button has disappeared. All the settings are the same. i can not figure out why. please help. Thanks!