I have an Excel workbook in which I have a number of worksheets.

In the worksheets I have created drop-down lists for various columns. Sometimes when I close the file and then open it later the drop-down lists disappear for some columns and then I have to reset them again. Sometimes when I reopen the file they are fine.

Any idea why this is happening?