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.
BrentM_500's avatar
BrentM_500
Copper Contributor
Apr 20, 2023

Hi all,

 

Interesting to see what you guys are seeing here..

 

Looks like there's varying results due to MSFT being in the middle of rolling the Beta functionality out slowly instead of all at once.

 

I just checked and mine is working OK.  I'm on Version 2305 (Build 16414.20000) - Beta Channel.

 

I need my app to work on my sister's MAC Excel, which I don't know yet if the MAC OS version will have this functionality and I can't find anything about MAC OS users being able to participate in the Beta Channel.

 

Thanks,

 

Brent