Excel Auto Generated Data Entry Form Shortcomings and Request

%3CLINGO-SUB%20id%3D%22lingo-sub-2137332%22%20slang%3D%22en-US%22%3EExcel%20Auto%20Generated%20Data%20Entry%20Form%20Shortcomings%20and%20Request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137332%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20has%20this%20incredible%20feature%20for%20auto%20generating%20a%20data%20entry%20form%20based%20on%20a%20selected%20table.%3C%2FP%3E%3CP%3EIn%20my%20table%2C%20certain%20columns%2C%20under%20data%20validation%20have%20drop%20down%20lists%20created.%20However%2C%20when%20Excel%20generates%20the%20data%20entry%20form%2C%20the%20entry%20form%20does%20not%20pick%20up%20on%20the%20drop%20down%20lists%20for%20assigned%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20the%20way%20the%20data%20entry%20form%20is%20today%2C%20it%20cannot%20be%20used%20for%20data%20entry%20since%20it%20does%20not%20pick%20up%20or%20display%20the%20drop%20down%20list%20for%20a%20given%20data%20entry%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20like%20to%20suggest%20this%20feature%20of%20the%20data%20entry%20form%20to%20include%20drop%20down%20lists%20if%20a%20drop%20down%20list%20has%20been%20created%20for%20certain%20cells%20in%20a%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2137332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2137391%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Auto%20Generated%20Data%20Entry%20Form%20Shortcomings%20and%20Request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137391%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20legacy%20feature%2C%20so%20I%20don't%20think%20they%20will%20update%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20building%20a%20%3CA%20href%3D%22https%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Epower%20app%3C%2FA%3E%20instead%2C%20but%20I%20would%20also%20suggest%20upgrading%20the%20data%20source%20to%20a%20SharePoint%20list%20instead%20of%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Excel has this incredible feature for auto generating a data entry form based on a selected table.

In my table, certain columns, under data validation have drop down lists created. However, when Excel generates the data entry form, the entry form does not pick up on the drop down lists for assigned cells.

 

As the way the data entry form is today, it cannot be used for data entry since it does not pick up or display the drop down list for a given data entry field.

 

Would like to suggest this feature of the data entry form to include drop down lists if a drop down list has been created for certain cells in a table. 

 

Thanks.

 

4 Replies

This is a legacy feature, so I don't think they will update it.

 

Try building a power app instead, but I would also suggest upgrading the data source to a SharePoint list instead of Excel.

@SimplyHuman 

Former Excel MVP John Walkenbach created a free enhanced data entry form.

His website doesn't exist anymore, but the workbook can be downloaded from https://web.archive.org/web/20190201175712/http://spreadsheetpage.com/index.php/dataform/download 

Thank you for your suggestion.
Appreciate your suggestion.