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.
Prash_MSFT's avatar
Prash_MSFT
Icon for Microsoft rankMicrosoft
Apr 27, 2023
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
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..

Resources