I have a Google Sheet application (url below) that uses dropdown menus to allow selection of data to display (one line selected from 5000). It works quite well BUT once the file is shared, for some users the drop-down options are not evident. They are restored if the sheet is downloaded into EXCEL, for example, but the reason for using SHEET is to avoid dependency on the user's own choice of spreadsheet application. Particularly sad is the failure of the android app.
What needs to happen to allow SHEET to work fully?