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 stopped working. Autocomplete is still checked in options, and everything is still the same setting that it was previously as far as anyone can tell. Please help!

Nothing in the message center about the issue this morning so I moved forward with putting in a ticket with MS. If you have that capability, I would recommend you do the same so that their AI will pick up on it. I titled mine "Autocomplete not working for data validation columns in Excel Online".I will keep you all posted on this form.

Yep, the same for me, and I really want to have it back.Just to underline... It's not working for online Excel, where we don't need to download updates.Hope Microsoft will fix it as soon as possible.

MS has escalated the ticket to the engineers. Hoping we have a fix soon.

Same here. Is this a new break in Excel online? This post looks very new and my end users said this just started happening. I'm goin going to put in a support ticket with MS to let them know.

Thanks for the heads up! I'll add that to the ticket along with this thread.

Autocomplete not working for data validation

73 Replies

fabiofeltrin
Copper Contributor
Apr 19, 2022
problem solved today! Thank you for the update
Brian_Lam
Copper Contributor
Apr 19, 2022
Yup, as others have stated, AutoComplete is back to working for us as of this morning.
mfree0107
Copper Contributor
Apr 19, 2022
Staff here also report that the function seems to have been restored.
HKirkland455
Copper Contributor
Apr 19, 2022
It's working again for my users! We didn't need to change anything. Finally!
- memap
  Copper Contributor
  Nov 09, 2023
  thank you very much!
- shaveradam
  Copper Contributor
  Apr 19, 2022
  HKirkland455 I can confirm it's working for us this morning as well.
speirce
Copper Contributor
Apr 19, 2022
It's fixed for me using Excel online. I didn't change anything.
S
Rusty1971
Copper Contributor
Apr 19, 2022
Mollierosemac
I changed Regional Format (File>Options>Regional Format Settings) from English (Australia) back to English (US) then reverted to English (Australia) again and it seemed to come good... for now... Will keep monitoring.
Brian_Lam
Copper Contributor
Apr 18, 2022
Not working in Excel Online for us right now...still very annoying. 😧
Adam Young
Brass Contributor
Apr 18, 2022
Just got confirmation from my users that this is working again. No word from Microsoft on the support ticket but its working again for my users.
- Runser
  Copper Contributor
  Apr 20, 2022
  Just following for any available info since tech support seems stumped. This is still not working (at least for me) in Excel desktop.
  - Benjamong
    Copper Contributor
    Apr 20, 2022
    That's strange. I tested it out yesterday and had no issues. Not sure if refreshing your browser would have any impact on it...
- Josh_71288
  Copper Contributor
  Apr 18, 2022
  Thank you for the update. Still not active for my users.
  - drewwolfe
    Copper Contributor
    Apr 18, 2022
    Probably still rolling out, might have done a test rollout for Adam and waiting for it to blow up or not.
BeninParaguay
Copper Contributor
Apr 18, 2022
Dealing with the same issue now for over a week. Hoping for a resolution, since the ALT+[Down arrow] added keystrokes to activate the autocomplete slows input down considerably.
SRubin_OCDOH
Copper Contributor
Apr 18, 2022
Following - Same issue for my entire department (~20 people) in excel desktop, excel online, and excel through teams

Forum Discussion

Autocomplete not working for data validation

73 Replies

Resources