Excel for Mac 2016 - Looking for Data Entry Form

I recently installed Office 365 on a new mac.  This includes the newest version of Excel for mac which is v 15.

I can't seem to locate the option to enter data by creating a data entry form.    Previously you'd go to (menu) DATA and select FORM after selecting the appropriate cells.    

In the windows versions you have to add this to the ribbon , but I don't see a way to add the feature to this version and it's something I really need.   Any help will be most appreciated!

Thanks!

 

Question Info


Last updated September 20, 2019 Views 25,232 Applies to:
Answer
Answer

Apparently it's another of the numerous casualties inflicted in the name of enhancements to Mac Office. Whether it remains available in the bowels of the program is uncertain at this point as there is no provision for customization in the program.

Use the Smiley @ the right end of the Ribbon to plead your case.

As an MVP my contributions here are purely voluntary.

Please mark Yes/No as to whether a Reply answers your question.

Regards,
Bob J.

11 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer

I have some good news to report. 

Recently, Microsoft has improved the Visual Basic experience in Excel 2016 for Mac. Don't get the idea that it is great, but they improved it enough to give you a working solution to the particular problem of not having the Data input form.

Please take a moment to read about J-Walk's free Enhanced Data input form. It's actually a bit nicer than the one we used to have in older versions of Excel. You will note that the site says flat out on the page "This add-in does not work with any version of Excel for Macintosh." Well, guess what? Version 3b now works in Excel 2016 for Mac, assuming you have installed the latest updates. I tested in Excel version 10.21 for Mac. Go to the Excel menu and choose About Excel to check your update level. If you're not at version 15.20 or 15.21 then head to Excel's Help menu and choose Check for Updates to get the updates. Here's a link to the product description page:

http://spreadsheetpage.com/index.php/dataform/home

After reading about the add-in, go to the download page. 

http://spreadsheetpage.com/index.php/dataform/download/

Click the Download link for version 3b (under the Excel 2007 heading). The download file will be named dataform3.zip.

In Finder, double-click the zip file and it will open a folder called dataform3. Go inside the folder and find dataform3.xlam. You can drag this file to a permanent location in which it can be used. I recommend making a folder called Add-ins in your Documents folder and drag dataform3.xlam into that folder.

Now, open Excel 2016. On the Tools menu choose Excel Add-ins. Click the Browse button and choose the saved file dataform3.xlam. Then click the Open button. When prompted about Macros, choose to allow Macros to run. 

Your Add-ins dialog should have the add-in listed and checked, like this:

Now you're ready to use the new add-in.

Select a cell in your data table. Then go to the Data tab of the Ribbon and you will see a new button off to the right labeled J-Walk Enhanced DataForm. Click this button to activate the J-Walk Enhanced Data Form.

Yay!!!!

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

58 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.