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.
JKPieterse's avatar
JKPieterse
Silver Contributor
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.
  • RobnGG's avatar
    RobnGG
    Copper Contributor
    Nov 06, 2024

    "Near" future :(

  • meadowsst's avatar
    meadowsst
    Copper Contributor
    Apr 05, 2024

    JKPieterse 

    I just experienced this issue with one of my clients who just got a new laptop and installed MSOffice365 (desktop version) after having used the workbook template for months without any issue on his old laptop.

     

    The issue was that the version of Office365 that was installed on his new laptop was Ver 220x.  I had him upgrade Office365 (end result was Ver 2403) and the autocomplete with validation drop-down lists functionality started working as it does for everyone else in his company using the same workbook template.

    • briannahoo's avatar
      briannahoo
      Copper Contributor
      Apr 05, 2024

      meadowsst Interesting, I am currently running V2403 on my computer at home. I will have to double check the version I have at the office. 

  • zorgnum's avatar
    zorgnum
    Brass Contributor
    Apr 20, 2023
    I'm not on the Insider version, it was working perfectly for me, it started working for a friend of mine, my son can't get it to work and it has just stopped working for me in the last 24 hours.
  • BrentM500's avatar
    BrentM500
    Copper Contributor
    Apr 05, 2023

    Hi JKPieterse 

    I signed up for the Insider version of Excel (https://insider.office.com/en-us/join/windows) and chose the Beta Channel. Re-initiated Excel and now the Form Control dropdown works like a charm!

    Thanks so much for your help..

    • zorgnum's avatar
      zorgnum
      Brass Contributor
      Apr 20, 2023

      BrentM500I had the autocomplete function working on my machine and it has suddenly just stopped working. This is sooooooo frustrating, I wish that excel users could be taken seriously with a stable piece of software to work with.

  • BrentM_500's avatar
    BrentM_500
    Copper Contributor
    Mar 14, 2023

    JKPieterse - thanks so much for the response.  That definitely explains things..  Hopefully it will come soon - a long time pending...  I've had to use Form Controls vs Active X controls for now because my app has to work on MAC.  But when AutoComplete works I will migrate the dropdowns to Data Validation lists..  Thanks again..

Resources