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 ...
I changed Regional Format (File>Options>Regional Format Settings) from English (Australia) back to English (US) then reverted to English (Australia) again and it seemed to come good... for now... Will keep monitoring.