Forum Discussion

BrentM500's avatar
BrentM500
Copper Contributor
Mar 12, 2023
Solved

Excel AutoComplete not working with Data Validation Lists even after following all fix suggestions

Hi, I would appreciate help with AutoComplete in Excel.   Problem: - Data Validation List created does not show suggestions when typing valid entries in the dropdown cell - Clicking on the dropd...
excel
Formulas and Functions
office 365
  • JKPieterse's avatar
    JKPieterse
    Mar 13, 2023
    Excel desktop will get those features you are asking for in the near future. Currently, this only works in Excel on-line and on the Insider version of Excel.
NickBerlow's avatar
NickBerlow
Copper Contributor
Apr 27, 2023

Prash_MSFT 

Thanks Prash.

Good to know it will be rolled out ASAP once the bugs are fixed. It's a really neat feature and no more messy crazy VBA or formulas or helper columns to get this working.

Cheers, have a good day.

muibeta's avatar
muibeta
Copper Contributor
Jun 23, 2023

This feature is available once more with this week's Microsoft 365 update.

  • kcampbell8965's avatar
    kcampbell8965
    Copper Contributor
    Jul 27, 2023

    muibeta  It is extremely frustrating.  A peer helped me develop a worksheet and he evidently had this option.    Not knowing the history, we rolled this out to a broad audience with pomp and circumstance.  As users accessed the worksheet, we discovered it worked for some and not for others.  

     

    I updated this morning and still don't have this functionality so I guess it is still not rolled out for all users.

    • SamB513's avatar
      SamB513
      Copper Contributor
      Aug 03, 2023

      fully updated (just tried, tells me I have the latest version) and no autocomplete.

       

      Because autocomplete is such a bleeding edge option for a thirty eight year old application... like, how much have MS made selling Excel over the decades and continue to rope in through Office365 licencing, yet they can't afford to put in basic features...

       

      I guess when you're too busy on moving things around in the UI you don't have time to actually implement "new" features..

      • zorgnum's avatar
        zorgnum
        Brass Contributor
        Aug 08, 2023

        SamB513this has been working on my machine for a few weeks but not for my son. The only reason we can find is that I'm using 64 bit excel and he, for some unknown reason, is using 32 bit excel. If you click File then Account and click the About Excel button, this is my version details - Microsoft® Excel® for Microsoft 365 MSO (Version 2307 Build 16.0.16626.20086) 64-bit.

        Strangely enough, on the main Account page, my version is reported as being 2307 (Build 16626.20134 Click-to-Run)

        Excel has been very problematic over the last few months - randomly crashing, mashing autorecovery files with much older files, it's been a real disappointment and, to get support, you have to pay.

Resources