Forum Discussion

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
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

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

zorgnum
Brass Contributor
Apr 20, 2023
I'm on Version 2303 (Build 16227.20280 Click-to-Run) and the autocomplete was working fine, then it just stopped yesterday. No updates are available and none have been done to explain what happened. It's really flaky performance from Microsoft, and I have to pay for support to have them explain why they can't provide something more stable.
- Skinned
  Copper Contributor
  Apr 22, 2023
  same here...