Forum Discussion
Autocomplete not working for data validation
At work we have a shared excel sheet (we open it on the web) and we use it to store data. We had it set up with data validation list's and when we typed into the boxes, it would autocomplete one of ...
Just following for any available info since tech support seems stumped. This is still not working (at least for me) in Excel desktop.
That's strange. I tested it out yesterday and had no issues. Not sure if refreshing your browser would have any impact on it...
- Someone else had an answer--at least to why it's broken. Why on earth MS tech support doesn't have this info (and has spent HOURS with me trying to fix it) is a whole other topic, I guess.
This might help anyone wondering if they're nuts or their Excel is corrupted, etc.
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-online-dropdowns/34561567-977a-4339-8dd1-db99e53b56bd