Apr 10 2022 09:07 PM
Apr 10 2022 09:07 PM
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.
Apr 19 2023 03:13 AM
Happening again, my autocomplete suddenly stopped working tried to downgrade to previous excel versions but still not working.
Apr 19 2023 03:28 AM
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! :)
Apr 27 2023 10:23 AM
May 06 2023 05:19 AM - edited May 06 2023 05:22 AM
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
May 15 2023 05:53 AM
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
May 27 2023 08:04 AM
It's better to follow this https://techcommunity.microsoft.com/t5/excel-blog/speed-up-data-entry-and-validation-with-autocomple... 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.