Using: Excel 2011 ver 14.4.7
I use a Data Table which has drop-down lists in many of the fields (columns).
When I automatically create (show) a Data Form in Excel 2011 from this Data Table , and try to use this form to create a new record, all of the correct fields are shown on the form but they are all blank user input fields.
How can I get the features which apply to the fields in the Data Table (for example a Drop-Down List), to get reflected in the Data Form?
Please see attached example.