Forum Discussion
Searchable dropdown was finally available, then it disappeared. Anyone know what's going on?
Hi everybody.
On the beta, 365 user, thrilled searchable dropdown validation lists were finally a built-in part of Excel--then it disappeared today. Worked great yesterday in the same workbook, now it's gone. I've restarted, copied the sheet to a new workbook, the feature just seems to have disappeared. Is there anything I can do to get it back? Was it rolled back for some reason? Thanks.
And as a PS: please don't comment if you can't lead me towards an answer to the stated problem. If you have useful info, great, things for me to try, also great, but I'm not on here trying to waste time or have meaningless interactions with people.
3 Replies
Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows
Availability and Feedback
AutoComplete for Data Validation drop-down list is available in Beta Channel with version 2112, build 16.0.14818.10000 or later. Please keep in mind features are enabled gradually to more and more users over time as we build confidence in the success of a feature working properly. And so, this feature may or may not be enabled on your computer immediately. When you do see it enabled, please try it out! We’d love to hear from you whether this meets your expectations or not. Please send us feedback!
Maybe this information will help you...if not, just ignore it.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
- That's just the thing--it looks like I'm updated past that version (I'm currently at Version 2203 Build 16.0.15018.20002). So I'm not asking about when it's getting rolled out, I'm asking if something has happened that accounts for why I had it & now I don't. For instance, did the team decide this functionality should be turned on & off somehow (and if so, where)? Or does this indicate there being something wrong with my Excel?
- Write a feedback or leave a comment in the link I sent.
Unfortunately I can't help you further because I don't have a beta version.
Thank you for your understanding and patience
