Forum Discussion
Solved
Excel - Data Validation - Auto complete stopped
We have a shared workbook. One of the users reported the data validation stopped allowing him to type a value and auto complete in the list. I have unprotected everything, but still it will not auto ...
It could be related to this note from 4/8:
We fixed an issue with selections not appearing or not visible after being chosen in some dropdown menus, especially in Dark Gray theme.
I'm also experiencing this on excel web. However, the person who created the document doesn't seem to have the same issue. I'm working on it over a VPN and have no access to the engine room.
Has there been any update on whether the bug is fixed or has it now become a feature? It's a pretty annoying feature, because honestly some of the text strings are pretty long and the chances of me typing them out correctly can be limited. It defeats the object of having a drop down!
- Just started working a couple days ago again for me!
