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 ...
It used to work fine for me last year, but since a week or so, it doesn't work anymore on my desktop version. I tried the suggestions here, but nothing works.
Prash_MSFT
Microsoft
MicrosoftThe AutoComplete for drop-down lists feature on Excel for Windows was in the process of rolling out to all Current Channel customers. As we roll it out, we also ensure things are working smoothly before we expand our rollout to larger numbers of users. Sometimes, based on user feedback, we find things aren't working as expected. This is rare. That said, we have confirmed one such issue, so we have rolled back (a.k.a. turned off) AutoComplete for drop-down lists for all our Current Channel users.
We apologize for any inconvenience this is causing you. We are working hard to fix the issue as we speak in order to restart rolling out AutoComplete for drop-down lists in Current Channel as soon as we can.
thanx,
Prash
We apologize for any inconvenience this is causing you. We are working hard to fix the issue as we speak in order to restart rolling out AutoComplete for drop-down lists in Current Channel as soon as we can.
thanx,
Prash
- It is now November 16. Still not working on 2021 LTSC (version 2108 build 14332.20604).
Prash_MSFT
Any update on this as it's been a month since this comment. Any other work arounds you can suggest?It's better to follow this https://techcommunity.microsoft.com/t5/excel-blog/speed-up-data-entry-and-validation-with-autocomplete-for/ba-p/3072083/page/2#comments blog. As Prash mentioned few days ago, feature will be available on Current channel "as soon as we can". Depends on users feedback and bugs appeared.
