Forum Discussion
Solved
Excel autocomplete was working with my data validations, now it isn't
It just suddenly stopped working. No recent updates are indicated in my update history.
- I'm on Version 2303 (Build 16227.20280 Click-to-Run) and the autocomplete was working fine, then it just stopped yesterday. No updates are available and none have been done to explain what happened. It's really flaky performance from Microsoft, and I have to pay for support to have them explain why they can't provide something more stable.
There must have been something else in place that changed. One way to achieve autocompletion with data validation is to put the data validation list above the cell with data validation. This works like it would work in any other cell .
Here is a link with information on how you can get a quick and precise solution proposal.
Welcome to your Excel discussion space!
I hope this helps!
the validation list is sourced from another sheet so that is not an option, and that is just repeating an existing entry on the sheet, not autocomplete - it was working fine and now it isn't. I'm seeing if other people I know are having the same problem.
zorgnum I am having the same problem. It was working and suddenly stop working whitout new updates
- I'm on Version 2303 (Build 16227.20280 Click-to-Run) and the autocomplete was working fine, then it just stopped yesterday. No updates are available and none have been done to explain what happened. It's really flaky performance from Microsoft, and I have to pay for support to have them explain why they can't provide something more stable.
I found a thread where users have reported similar issues with autocomplete not working for data validation in a shared Excel sheet opened on the web.
However, I couldn’t find any specific solutions or reasons for why this issue might be occurring.