Forum Discussion

Mollierosemac's avatar
Mollierosemac
Brass Contributor
Apr 11, 2022

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 ...
excel
Excel for web
Formulas and Functions
Adnan1980's avatar
Adnan1980
Copper Contributor
May 06, 2023

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 

  • JPR1980's avatar
    JPR1980
    Copper Contributor
    May 15, 2023

    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 

Resources