Data Validation - Auto complete stopped functioning

[wrose51106]

We have a shared workbook with data validation. Everyone uses Offie 365. Last week after someone messed with sheet protection, someone reported that auto complete stopped working in the data validation, it was rebuilt but no effect for the user. Now it has stopped for me, on all workbooks I create. Any idea where to begin?

 

[RoryA]

If you're using Excel online, you're always on the most recent version.

 

[Fluff]

As far as formula functions are concerned, the online version is the same as 365

 

[Gary McMaster]

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 the options. Now, you have to click the down box then start typing because autocomplete has...

techcommunity.microsoft.com

Prash Shirolkar
replied to RichardV370

‎Apr 27 2023 10:23 AM
The 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