Forum Discussion
Excel AutoComplete not working with Data Validation Lists even after following all fix suggestions
- Excel desktop will get those features you are asking for in the near future. Currently, this only works in Excel on-line and on the Insider version of Excel.
MicrosoftUpdate... AutoComplete for dropdown lists feature is now available in Current Channel starting with version 2306 build 16.0.16501.20004 or later!
When you see it please try it out! We’d love to hear from you whether this meets your expectations or not. Please send us feedback!
thanx,
Prash
Prash_MSFT I am running Version 2311 (Build 17029.20068) and am still not able to use the autocomplete feature with my data validation lists. Do you have any insight into what I need to do to access this feature? I can use it on my office computer with a different login, I am just not there now to access the version I have there.
briannahoo Did you ever get an answer to this? I've got the same problem (though I'm running Version 2311 Build 17029.20108) and I can't get auto-complete to work. Are you using Office 365 or do you have a non-subscription based perpetual version? I've got a perpetual version (Professional Plus 2021) and I'm wondering if that is the problem.
As per my post June 23, 2023, following a Microsoft 365 update, autocomplete of lists started working again for me and has worked faultlessly since. I am currently running the desktop version of a Microsoft 365 subscription (that includes Excel version 2312 build 17126.20078) under Windows 11. jasonvr
muibeta Great that it's working for you, but your post is kind of confirming my suspicion. I (and I suspect briannahoo) are both running the perpetual versions and you're running Office 365. Neither of us have it working and you do.
