Been using data validation with a drop down list on a column in a worksheet for months with no issue.
Today I have noticed that there is no longer a drop down list on any of these cells, and instead all I can do is enter text manually.
I've check the data validation rule and it's still set to list, and have confirmed the source range is still correct. In-cell drop down option still ticked. No idea where else to look or why this has suddenly stopped working. Excel 2016 on Windows 10. Could anybody help please?
Today I have noticed that there is no longer a drop down list on any of these cells, and instead all I can do is enter text manually.
I've check the data validation rule and it's still set to list, and have confirmed the source range is still correct. In-cell drop down option still ticked. No idea where else to look or why this has suddenly stopped working. Excel 2016 on Windows 10. Could anybody help please?