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 ...
Back in April it was only occurring in Excel Online and the fix was something MS did on their end that was never explained. It just resolved itself so it must have been some patch they deployed to the online version that broke it and maybe they just rolled it back.
My recommendation would be a ticket to Microsoft. There was no actual solution you could apply to fix this.
My recommendation would be a ticket to Microsoft. There was no actual solution you could apply to fix this.
It's December and I am rolling over this years file and setting up next year's. The autocomplete doesn't work on a data validation list.
