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.

Resources