Forum Discussion
Excel mobile workaround to form control
Hi I have recently developed an excel based progress sheet (with assistance from this forum) for our site based subcontractors. This uses the tick boxes and some macro's, but I save the sheets as...
- Ditch the form controls and use simple Data Validation List option with a Yes/No choice. Then make sure your data is formatted as a table so the users can use Android Excel's great feature to edit records in a table: https://support.microsoft.com/en-us/office/use-cards-view-to-work-with-table-data-on-your-phone-fda6099e-2de8-4a52-a926-90a7ee61a32b
Ditch the form controls and use simple Data Validation List option with a Yes/No choice. Then make sure your data is formatted as a table so the users can use Android Excel's great feature to edit records in a table: https://support.microsoft.com/en-us/office/use-cards-view-to-work-with-table-data-on-your-phone-fda6099e-2de8-4a52-a926-90a7ee61a32b
