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.
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.
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.