Mar 12 2023 01:33 PM
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 dropdown shows the list but typing while the list is dropped down does nothing
- Just typing directly into the cell types the characters but does not provide suggestions for matching entries to choose from
- Case doesn't seem to matter - inputting the exact case of the text or all in lower case makes no difference
Things tried:
- Checked that "Enable AutoComplete for cell values" and "Automatically Flash Fill" are checked (tried while removing "Automatically Flash Fill" turned off but no difference)
- Made sure "Ignore Blank" and "In-cell Dropdown" are checked
- Made sure there are no headers above the list data linked to the dropdown
- Opened new sheet and tried from zero with no luck
- Tried with both .xlsx and .xlsm files
I'm at a loss here. Any recommendations appreciated..
Thank You,
Brent
Mar 13 2023 02:55 AM
SolutionMar 14 2023 09:55 AM
@Jan Karel Pieterse - 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..
Apr 04 2023 10:52 AM
Apr 05 2023 12:20 AM
Apr 05 2023 07:44 AM - edited Apr 05 2023 07:45 AM
Hi @Jan Karel Pieterse
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..
Apr 19 2023 07:28 PM
@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.
Apr 20 2023 03:20 AM
Apr 20 2023 05:44 AM
Apr 20 2023 11:46 AM
Apr 20 2023 12:20 PM
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
Apr 20 2023 01:48 PM
Apr 22 2023 11:08 AM
Apr 26 2023 11:09 PM
Hello Jan, do you have any approximate date or time frame that Microsoft will bring this feature back? It's so very useful for a range of business applications and for when designing data entry sheets for users with low excel skill/knowledge.
Thanks.
Apr 27 2023 09:40 AM
Apr 27 2023 02:56 PM
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.
Jun 23 2023 02:51 AM
This feature is available once more with this week's Microsoft 365 update.
Jul 27 2023 06:14 AM
@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.
Aug 03 2023 12:16 AM
fully updated (just tried, tells me I have the latest version) and no autocomplete.
Because autocomplete is such a bleeding edge option for a thirty eight year old application... like, how much have MS made selling Excel over the decades and continue to rope in through Office365 licencing, yet they can't afford to put in basic features...
I guess when you're too busy on moving things around in the UI you don't have time to actually implement "new" features..
Mar 13 2023 02:55 AM
Solution