Forum Discussion
results in cell with data validation
Hi, in have a cell with a data validation dropdown list and in the past when i typed in a word all possible results popped up. I am using office 2016. I did a system restore and suddenly this stopped...
As far as I know, this functionality was introduced with Excel 365, many years after Excel 2016 has been released. If you want the behaviour back, I expect your only option is to either purchase a 365 subscription, or buy Office 2024 (I think!)
dominiek3are you saying AS you type the dropdown lists is actively filtered for possible matches OR, as I suspect, is this using the old way where you type in a word (hit enter) and then the data validation list would be updated to show only the matching values. Assuming that is the case, please attach the workbook without any personal/private information or an example. It may be that something else broke and happen to coincide with the resote process.