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