I have created a data validation list: when users are access the file through SharePoint (office 365), they can start typing a topic and the validation returns a short list based on the keyword. When users have the sheet open in the desk app, the functionality isn't the same. How can I modify the settings so typing in a cell will short list the data validation results?
