Versions that Have AutoComplete for Data Validation

Hello,   I have shared workbooks that could greatly be improved by having autocomplete for data validation, but it doesn't work for me. I've read various post about it working online, which it does...