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!
i also have same issue and I contacted with Microsoft support team, they got control of my pc for two days and failed to resolve the issue. in the end they given up by sayin your windows is not activated so that auto complete dropdown is not working while I check on my another pc which has registered windows and registered Office 365 and this option also not working on that.. means Microsoft team is not enough expert to handle this job Mollierosemac
It has to be something in windows. I am able to take the spreadsheet to my personal pc or laptop and the autocomplete works just fine. There seems to be something on the local end, in windows, that is not being allowed to run under the administered GP. I am just unsure at what to look at Adnan1980
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
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- It is now November 16. Still not working on 2021 LTSC (version 2108 build 14332.20604).
Clear your browser’s cache and cookies:
Sometimes, clearing your browser’s cache and cookies can help resolve issues with web-based applications.
Try clearing your browser’s cache and cookies and then reopening the Excel file to see if that helps.
I hope this helps! 🙂
Happening again, my autocomplete suddenly stopped working tried to downgrade to previous excel versions but still not working.
Its April 2023 and same issue as last year, suddenly autocomplete stopped working.
Mollierosemac If you are still looking for a resolution, here is an option, insert a blank row between your headings and your data. That's it.
Hope this helps!
10/10/22-data validation autocomplete suddenly stopped working...what was the fix for this issue back in April?!
- Back in April it was only occurring in Excel Online and the fix was something MS did on their end that was never explained. It just resolved itself so it must have been some patch they deployed to the online version that broke it and maybe they just rolled it back.
My recommendation would be a ticket to Microsoft. There was no actual solution you could apply to fix this.It's December and I am rolling over this years file and setting up next year's. The autocomplete doesn't work on a data validation list.
- Hello! is there a release version I can reference that has for the autocomplete from a list? I am using Office365 Desktop, no beta. Has this been fully rolled out? Its June and it looks like the last reports on this were months ago. Thanks!!
As an alternative, on desktop version, you can have the autocomplete functionality by using a free Excel add-in "Search deList". You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/
It gives you a unique, sorted & non-empty list, and you can search by multiple keywords.Perfect timing for purchasing 365... Can't tell if it was working before, for sure it doesn't work now.
EU region. Desktop app.
