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 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.following this as I am having the same issue hoping someone gets a solution.
- 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.
- Correct! It has only started happening about roughly 1 week ago
- Thanks for the heads up! I'll add that to the ticket along with this thread.
- Update, there is no update. MS is still working on it apparently. Just wanted to give a latest on the situation.
Mollierosemac
Hi there,
I find out the way to make it a little bit easier..
When you're on the cell with dropdown list, you can press "Alt + arrow Down" to open the dropdown list and then start to type what you need to search. And it's working. Of course, it's not so comfortable as it was before, but better than nothing.
Have a great day
Best regards,
Andrey 🙂- Thank you so much for this temporary solution. At least I can keep working fluidly now, even if it takes a bit more time
Mollierosemac I have the same problem and it's driving me crazy! I'd love any solutions to allow me to return to autocomplete.
- Same problem, following for resolution.
- same problem....
- This is driving me crazy as well! Microsoft better have a quick solution for this. Hoping its just an update glitch, that they'll resolve soon.
