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...
To resolve the issue of data validation dropdown lists not showing possible results as you type in Excel 2016 after a system restore, try the following steps:
- Check AutoComplete settings: Go to File > Options > Advanced. Under the "Editing options" section, make sure "Enable AutoComplete for cell values" is checked.
- Re-enable the dropdown list: Click on the cell with the dropdown, go to Data > Data Validation, and check if the settings are correct. Make sure the "Allow" field is set to "List."
- Clear Cache/Temporary Files: Clear Excel's temporary files by closing Excel and deleting its cache in the system's temp folder (press Win+R, type %temp%, and delete files).
- Repair Office: Go to Control Panel > Programs > Programs and Features, select Microsoft Office 2016, and click "Repair" to fix potential issues.
These steps should restore the dropdown functionality and allow AutoComplete to work again.