Missing Feature in Excel Mac 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-292209%22%20slang%3D%22en-US%22%3EMissing%20Feature%20in%20Excel%20Mac%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292209%22%20slang%3D%22en-US%22%3E%3CP%3ERecently%20obtained%20a%20new%20MacBookPro%20and%20installed%20MS%20Office%202019.%20This%20machine%20replaces%20another%20MBP%2C%20also%20with%20MS%20Office%2C%20although%20an%20earlier%20version.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20numerous%20spreadsheets%20with%20database%20capability%2C%20and%20used%20the%20data%20entry%20Form...%20option.%20This%20Form...%20option%20was%20available%20in%20the%20Data%20dropdown%20menu%2C%20grouped%20with%20the%20Subtotals...%20and%20Validation...%20options.%20%26nbsp%3BThe%20Form...%20option%20is%20no%20longer%20available%20in%20Excel%202019.%20I%20have%20been%20using%20this%20Form...%20option%20since%201990%20in%20numerous%20spreadsheets%2C%20particularly%20in%20spreadsheets%20with%20database%20capability.%20This%20option%20is%20not%20to%20be%20found%20in%20Excel%202019%2C%20and%20it%20is%20very%20disappointing.%20This%20could%20very%20well%20cause%20me%20to%20redesign%20how%20I%20use%20a%20spreadsheet%20and%20switch%20to%20and%20recommend%20Apple%20Numbers%20instead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20anybody%20find%20the%20Form...%20option%20in%20Excel%20Mac%202019%3F%20I%20have%20tried%20many%20of%20the%20means%20posted%20for%20finding%20the%20Form...%20option%20in%20previous%20editions%20of%20Excel%20and%20none%20of%20them%20worked.%20Actually%2C%20one%20of%20those%20methods%20appears%20to%20confirm%20that%20the%20Form...%20option%20has%20been%20removed%20from%20Excel%20Mac%202019%2C%20if%20it%20is%20a%20valid%20technique%20for%20Excel%202019.%20I%20used%20the%20technique%20for%20adding%20the%20Form...%20option%20to%20the%20Ribbon%20in%20Excel%202016%20and%20although%20that%20works%2C%20the%20Form...%20option%20is%20no%20longer%20an%20option%20to%20add%20to%20the%20Ribbon%20as%20it%20was%20in%20Excel%20Mac%202016.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20library%20of%20spreadsheet%20templates%20that%20MS%20provides%20really%20need%20this%20Form...%20feature%20or%20the%20spreadsheets%20are%20a%20brute%20to%20work.%20This%20Form...%20feature%20must%20be%20found%20or%20returned%20to%20Excel%20Mac%202019%2C%20and%20quickly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-292209%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2127316%22%20slang%3D%22en-US%22%3ERe%3A%20Missing%20Feature%20in%20Excel%20Mac%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2127316%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246858%22%20target%3D%22_blank%22%3E%40Acadia1532%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Data%20Entry%20Form%20isn't%20in%20these%20Excel%20reference%20books%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.amazon.com%2FLearn-Excel-Essential-Skills-Method%2Fdp%2F1909253324%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.amazon.com%2FLearn-Excel-Essential-Skills-Method%2Fdp%2F1909253324%3C%2FA%3E%3C%2FP%3E%3CP%3Ethere%20is%20no%20chance%20to%20make%20it%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards.%3C%2FP%3E%3CP%3ECrigou%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Recently obtained a new MacBookPro and installed MS Office 2019. This machine replaces another MBP, also with MS Office, although an earlier version. 

 

I use numerous spreadsheets with database capability, and used the data entry Form... option. This Form... option was available in the Data dropdown menu, grouped with the Subtotals... and Validation... options.  The Form... option is no longer available in Excel 2019. I have been using this Form... option since 1990 in numerous spreadsheets, particularly in spreadsheets with database capability. This option is not to be found in Excel 2019, and it is very disappointing. This could very well cause me to redesign how I use a spreadsheet and switch to and recommend Apple Numbers instead.

 

So, anybody find the Form... option in Excel Mac 2019? I have tried many of the means posted for finding the Form... option in previous editions of Excel and none of them worked. Actually, one of those methods appears to confirm that the Form... option has been removed from Excel Mac 2019, if it is a valid technique for Excel 2019. I used the technique for adding the Form... option to the Ribbon in Excel 2016 and although that works, the Form... option is no longer an option to add to the Ribbon as it was in Excel Mac 2016. 

 

The library of spreadsheet templates that MS provides really need this Form... feature or the spreadsheets are a brute to work. This Form... feature must be found or returned to Excel Mac 2019, and quickly.

1 Reply

@Acadia1532 

 

Hi.

 

If the Data Entry Form isn't in these Excel reference books:

https://www.amazon.com/Learn-Excel-Essential-Skills-Method/dp/1909253324

there is no chance to make it to work.

 

Regards.

Crigou