Forum Discussion
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 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.
So here has been my strange experience with this. I and a colleague within my organization are working from the same shared Excel worksheet. We both have the same version of Excel and we both have the workbook open in the desktop version of Excel. I have access to the AutoComplete feature with the Data Validation lists, but my colleague does not.
This is because features may be gradually distributed to users. A random part of the users on a certain build will get feature A, the others will not. The more certain MSFT is about an update, the higher the percentage that gets it first time round.
Your colleague should see this feature enabled in due course.
Your colleague should see this feature enabled in due course.
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.
JKPieterse
I appreciate this helpful update. Thank you.
