Autocomplete not working for data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-3281479%22%20slang%3D%22en-US%22%3EAutocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281479%22%20slang%3D%22en-US%22%3E%3CP%3EAt%20work%20we%20have%20a%20shared%20excel%20sheet%20(we%20open%20it%20on%20the%20web)%20and%20we%20use%20it%20to%20store%20data.%3C%2FP%3E%3CP%3EWe%20had%20it%20set%20up%20with%20data%20validation%20list's%20and%20when%20we%20typed%20into%20the%20boxes%2C%20it%20would%20autocomplete%20one%20of%20the%20options.%20Now%2C%20you%20have%20to%20click%20the%20down%20box%20then%20start%20typing%20because%20autocomplete%20has%20stopped%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAutocomplete%20is%20still%20checked%20in%20options%2C%20and%20everything%20is%20still%20the%20same%20setting%20that%20it%20was%20previously%20as%20far%20as%20anyone%20can%20tell.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3281479%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3291131%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3291131%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20an%20alternative%2C%20on%20desktop%20version%2C%20you%20can%20have%20the%20autocomplete%20functionality%20by%20using%20a%20free%20Excel%20add-in%20%22Search%20deList%22.%20You%20can%20find%20it%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fi-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fi-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466%2F%3C%2FA%3E%3CBR%20%2F%3EIt%20gives%20you%20a%20unique%2C%20sorted%20%26amp%3B%20non-empty%20list%2C%20and%20you%20can%20search%20by%20multiple%20keywords.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3291003%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3291003%22%20slang%3D%22en-US%22%3E%3CP%3EPerfect%20timing%20for%20purchasing%20365...%20Can't%20tell%20if%20it%20was%20working%20before%2C%20for%20sure%20it%20doesn't%20work%20now.%3C%2FP%3E%3CP%3EEU%20region.%20Desktop%20app.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290513%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290513%22%20slang%3D%22en-US%22%3ESomeone%20else%20had%20an%20answer--at%20least%20to%20why%20it's%20broken.%20Why%20on%20earth%20MS%20tech%20support%20doesn't%20have%20this%20info%20(and%20has%20spent%20HOURS%20with%20me%20trying%20to%20fix%20it)%20is%20a%20whole%20other%20topic%2C%20I%20guess.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20might%20help%20anyone%20wondering%20if%20they're%20nuts%20or%20their%20Excel%20is%20corrupted%2C%20etc.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fexcel-online-dropdowns%2F34561567-977a-4339-8dd1-db99e53b56bd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fexcel-online-dropdowns%2F34561567-977a-4339-8dd1-db99e53b56bd%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290373%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290373%22%20slang%3D%22en-US%22%3EThat's%20strange.%20I%20tested%20it%20out%20yesterday%20and%20had%20no%20issues.%20Not%20sure%20if%20refreshing%20your%20browser%20would%20have%20any%20impact%20on%20it...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3290277%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3290277%22%20slang%3D%22en-US%22%3EJust%20following%20for%20any%20available%20info%20since%20tech%20support%20seems%20stumped.%20This%20is%20still%20not%20working%20(at%20least%20for%20me)%20in%20Excel%20desktop.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289344%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289344%22%20slang%3D%22en-US%22%3E%3CP%3Eproblem%20solved%20today!%20Thank%20you%20for%20the%20update%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289333%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289333%22%20slang%3D%22en-US%22%3EYup%2C%20as%20others%20have%20stated%2C%20AutoComplete%20is%20back%20to%20working%20for%20us%20as%20of%20this%20morning.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289276%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289276%22%20slang%3D%22en-US%22%3EStaff%20here%20also%20report%20that%20the%20function%20seems%20to%20have%20been%20restored.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289252%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289252%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1360244%22%20target%3D%22_blank%22%3E%40HKirkland455%3C%2FA%3E%26nbsp%3BI%20can%20confirm%20it's%20working%20for%20us%20this%20morning%20as%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289192%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289192%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20working%20again%20for%20my%20users!%26nbsp%3B%20We%20didn't%20need%20to%20change%20anything.%26nbsp%3B%20Finally!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3289014%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3289014%22%20slang%3D%22en-US%22%3EIt's%20fixed%20for%20me%20using%20Excel%20online.%20I%20didn't%20change%20anything.%3CBR%20%2F%3ES%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288859%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288859%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20changed%20Regional%20Format%20(File%26gt%3BOptions%26gt%3BRegional%20Format%20Settings)%20from%20English%20(Australia)%20back%20to%20English%20(US)%20then%20reverted%20to%20English%20(Australia)%20again%20and%20it%20seemed%20to%20come%20good...%20for%20now...%20Will%20keep%20monitoring.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288767%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288767%22%20slang%3D%22en-US%22%3ENot%20working%20in%20Excel%20Online%20for%20us%20right%20now...still%20very%20annoying.%20%3CLI-EMOJI%20id%3D%22lia_anguished-face%22%20title%3D%22%3Aanguished_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288704%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1361511%22%20target%3D%22_blank%22%3E%40drewwolfe%3C%2FA%3E%26nbsp%3Bconfirmed%20still%20not%20working%20for%20us%20either%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288700%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288700%22%20slang%3D%22en-US%22%3EProbably%20still%20rolling%20out%2C%20might%20have%20done%20a%20test%20rollout%20for%20Adam%20and%20waiting%20for%20it%20to%20blow%20up%20or%20not.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288677%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288677%22%20slang%3D%22en-US%22%3EThank%20you%20for%20the%20update.%20Still%20not%20active%20for%20my%20users.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288673%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288673%22%20slang%3D%22en-US%22%3EJust%20got%20confirmation%20from%20my%20users%20that%20this%20is%20working%20again.%20No%20word%20from%20Microsoft%20on%20the%20support%20ticket%20but%20its%20working%20again%20for%20my%20users.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288202%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288202%22%20slang%3D%22en-US%22%3EDealing%20with%20the%20same%20issue%20now%20for%20over%20a%20week.%20Hoping%20for%20a%20resolution%2C%20since%20the%20ALT%2B%5BDown%20arrow%5D%20added%20keystrokes%20to%20activate%20the%20autocomplete%20slows%20input%20down%20considerably.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3288195%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3288195%22%20slang%3D%22en-US%22%3EFollowing%20-%20Same%20issue%20for%20my%20entire%20department%20(~20%20people)%20in%20excel%20desktop%2C%20excel%20online%2C%20and%20excel%20through%20teams%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3287010%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3287010%22%20slang%3D%22en-US%22%3ESame%20problem%20here%2C%20following%20for%20resolution%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286813%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F114413%22%20target%3D%22_blank%22%3E%40Adam%20Young%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20update.%20My%20colleague%20and%20I%20have%20the%20same%20issue%20-%20live%20document%20that%20we%20add%20data%20to%20all%20day%20every%20day%2C%20and%20this%20has%20made%20it%20tedious.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286763%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286763%22%20slang%3D%22en-US%22%3EThey%20had%20me%20reproduce%20the%20issue%20while%20running%20a%20fiddler%20log%20trace%20and%20screen%20recording%20session.%20Not%20sure%20why%20they%20wouldn't%20just%20reproduce%20the%20issue%20on%20their%20end%20but%20what%20ever.%20Hopefully%20support%20will%20start%20getting%20serious%20about%20this.%20If%20you%20have%20not%20already%2C%20you%20all%20should%20put%20in%20support%20tickets%20on%20it.%20You%20can%20reference%20my%20support%20case%20if%20you%20like.%20Ticket%20%2330639978%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286714%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286714%22%20slang%3D%22en-US%22%3EMy%20team%20is%20having%20the%20same%20problem.%20Following%20for%20a%20solution.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286711%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286711%22%20slang%3D%22en-US%22%3E%3CP%3EFollowing%20as%20we%20are%20having%20the%20same%20issue%20-%20hoping%20for%20a%20fix%20soon!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286624%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286624%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20for%20this%20temporary%20solution.%20At%20least%20I%20can%20keep%20working%20fluidly%20now%2C%20even%20if%20it%20takes%20a%20bit%20more%20time%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286623%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286623%22%20slang%3D%22en-US%22%3EI'm%20also%20having%20this%20issue%2C%20which%20started%20for%20me%20on%20April%207th.%20At%20least%20I'm%20not%20suffering%20alone%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286130%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286130%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20here%20as%20of%20about%20April%2012.%26nbsp%3B%20Watching%20thread%20for%20resolution.%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3286099%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3286099%22%20slang%3D%22en-US%22%3ESame%20issue%20here%20since%20Apr%2011%2C%20very%20frustrating.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3285347%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3285347%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EHi%20there%2C%26nbsp%3B%3CBR%20%2F%3EI%20find%20out%20the%20way%20to%20make%20it%20a%20little%20bit%20easier..%26nbsp%3B%3CBR%20%2F%3EWhen%20you're%20on%20the%20cell%20with%20dropdown%20list%2C%20you%20can%20press%20%22Alt%20%2B%20arrow%20Down%22%20to%20open%20the%20dropdown%20list%20and%20then%20start%20to%20type%20what%20you%20need%20to%20search.%20And%20it's%20working.%20Of%20course%2C%20it's%20not%20so%20comfortable%20as%20it%20was%20before%2C%20but%20better%20than%20nothing.%26nbsp%3B%3CBR%20%2F%3EHave%20a%20great%20day%3CBR%20%2F%3EBest%20regards%2C%26nbsp%3B%3CBR%20%2F%3EAndrey%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284779%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284779%22%20slang%3D%22en-US%22%3EUpdate%2C%20there%20is%20no%20update.%20MS%20is%20still%20working%20on%20it%20apparently.%20Just%20wanted%20to%20give%20a%20latest%20on%20the%20situation.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284288%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284288%22%20slang%3D%22en-US%22%3ESame%20issue%20here%2C%20glad%20to%20see%20it's%20escalated%20to%20MS.%20This%20is%20costing%20our%20entire%20department%20a%20big%20chunck%20of%20extra%20time%20every%20day.%20All%20team%20members%20have%20this%20issue%20(8%20ppl)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3284257%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3284257%22%20slang%3D%22en-US%22%3ESame%20problem%20here%2C%20following...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283809%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283809%22%20slang%3D%22en-US%22%3ESame%20issue%20here%20-%20following%2C%20glad%20to%20see%20it's%20not%20just%20me%2C%20is%20very%20frustrating.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283745%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3B%20following%20so%20I%20hopefully%20see%20a%20solution%20too%20-%20we're%20having%20the%20same%20issue%20and%20it's%20very%20frustrating!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283591%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283591%22%20slang%3D%22en-US%22%3ESo%20frustrating!%20hoping%20it%20gets%20resolved%20quickly%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283468%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283468%22%20slang%3D%22en-US%22%3EMS%20has%20escalated%20the%20ticket%20to%20the%20engineers.%20Hoping%20we%20have%20a%20fix%20soon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283443%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283443%22%20slang%3D%22en-US%22%3E%3CP%3Efollowing%20this%20as%20I%20am%20having%20the%20same%20issue%20hoping%20someone%20gets%20a%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283228%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283228%22%20slang%3D%22en-US%22%3ENothing%20in%20the%20message%20center%20about%20the%20issue%20this%20morning%20so%20I%20moved%20forward%20with%20putting%20in%20a%20ticket%20with%20MS.%20If%20you%20have%20that%20capability%2C%20I%20would%20recommend%20you%20do%20the%20same%20so%20that%20their%20AI%20will%20pick%20up%20on%20it.%20I%20titled%20mine%20%22Autocomplete%20not%20working%20for%20data%20validation%20columns%20in%20Excel%20Online%22.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20will%20keep%20you%20all%20posted%20on%20this%20form.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283180%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1360983%22%20target%3D%22_blank%22%3E%40speirce%3C%2FA%3E%26nbsp%3BSame%20here.%20I%20got%20bombarded%20with%20messages%20from%20my%20end%20users%20first%20thing%20on%20a%20Monday%20morning.%20Way%20to%20start%20the%20week.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3283050%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3283050%22%20slang%3D%22en-US%22%3EAnd%20me.%20Just%20irritating%20when%20things%20change%20unexpectedly%20and%20for%20the%20worse.%3CBR%20%2F%3ES%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282797%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282797%22%20slang%3D%22en-US%22%3EYep%2C%20the%20same%20for%20me%2C%20and%20I%20really%20want%20to%20have%20it%20back.%3CBR%20%2F%3EJust%20to%20underline...%20It's%20not%20working%20for%20online%20Excel%2C%20where%20we%20don't%20need%20to%20download%20updates.%3CBR%20%2F%3EHope%20Microsoft%20will%20fix%20it%20as%20soon%20as%20possible.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282614%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282614%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20-%20autocomplete%20not%20working%20as%20of%207%20April.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282547%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282547%22%20slang%3D%22en-US%22%3EGreat%20thank%20you%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282541%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282541%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20heads%20up!%20I'll%20add%20that%20to%20the%20ticket%20along%20with%20this%20thread.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282536%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282536%22%20slang%3D%22en-US%22%3ECorrect!%20It%20has%20only%20started%20happening%20about%20roughly%201%20week%20ago%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282526%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282526%22%20slang%3D%22en-US%22%3ESame%20here.%20Is%20this%20a%20new%20break%20in%20Excel%20online%3F%20This%20post%20looks%20very%20new%20and%20my%20end%20users%20said%20this%20just%20started%20happening.%20I'm%20goin%20going%20to%20put%20in%20a%20support%20ticket%20with%20MS%20to%20let%20them%20know.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282497%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282497%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20do%20this%20too%2C%20but%20found%20we%20save%20so%20much%20time%20when%20we%20can%20just%20click%20tab%20to%20the%20next%20box%2C%20type%2C%20then%20tab%20to%20the%20next%3B%20rather%20than%20clicking%20and%20typing!%20Thanks%20for%20the%20heads%20up%20but%20hopefully%20there%20is%20a%20resolution%20to%20the%20issue%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359854%22%20target%3D%22_blank%22%3E%40Josh_71288%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282393%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282393%22%20slang%3D%22en-US%22%3EThis%20is%20driving%20me%20crazy%20as%20well!%20Microsoft%20better%20have%20a%20quick%20solution%20for%20this.%20Hoping%20its%20just%20an%20update%20glitch%2C%20that%20they'll%20resolve%20soon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282380%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282380%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20here%3B%20following%20for%20resolution.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282081%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282081%22%20slang%3D%22en-US%22%3EI%20was%20struggling%20with%20this%20as%20well.%3CBR%20%2F%3EI%20have%20found%20a%20work%20around%20that%20help%20my%20team.%3CBR%20%2F%3ETry%20to%20click%20into%20the%20cell%20select%20the%20dropdown%20chevron%20then%20start%20to%20type.%20The%20auto%20complete%20should%20start%20to%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3282063%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3282063%22%20slang%3D%22en-US%22%3EI%20am%20have%20the%20same%20issue%20today.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281960%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281960%22%20slang%3D%22en-US%22%3EI%20was%20struggling%20with%20this%20as%20well.%3CBR%20%2F%3EI%20have%20found%20a%20work%20around%20that%20help%20my%20team.%3CBR%20%2F%3ETry%20to%20click%20into%20the%20cell%20select%20the%20dropdown%20chevron%20then%20start%20to%20type.%20The%20auto%20complete%20should%20start%20to%20work.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281664%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281664%22%20slang%3D%22en-US%22%3Esame%20problem....%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281660%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281660%22%20slang%3D%22en-US%22%3ESame%20problem%2C%20following%20for%20resolution.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281578%22%20slang%3D%22en-US%22%3ERe%3A%20Autocomplete%20not%20working%20for%20data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1359356%22%20target%3D%22_blank%22%3E%40Mollierosemac%3C%2FA%3E%26nbsp%3BI%20have%20the%20same%20problem%20and%20it's%20driving%20me%20crazy!%20I'd%20love%20any%20solutions%20to%20allow%20me%20to%20return%20to%20autocomplete.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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!

55 Replies

@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....
I was struggling with this as well.
I have found a work around that help my team.
Try to click into the cell select the dropdown chevron then start to type. The auto complete should start to work.
I am have the same issue today.
I was struggling with this as well.
I have found a work around that help my team.
Try to click into the cell select the dropdown chevron then start to type. The auto complete should start to work.

Same issue here; following for resolution. 

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.

We do this too, but found we save so much time when we can just click tab to the next box, type, then tab to the next; rather than clicking and typing! Thanks for the heads up but hopefully there is a resolution to the issue @Josh_71288 

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.
Great thank you so much

Same issue - autocomplete not working as of 7 April.

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.
And me. Just irritating when things change unexpectedly and for the worse.
S

@speirce Same here. I got bombarded with messages from my end users first thing on a Monday morning. Way to start the week. 

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.