Nov 14 2018 08:40 AM
I recently switched from PC to Mac. Then I found my Microsoft Access not available on Mac version Office. I tried to use Excel instead by creating a data entry form. Windows Excel 2016 is ok. But Mac Excel 2019 does not have this function. Any alternative to this great feature? Why Microsoft disabled this form on its new Excel? Thanks.
Nov 14 2018 08:43 AM
Nov 14 2018 08:56 AM
Nov 27 2018 04:38 PM
Yep, where is it?
Need the data entry form, it is valuable for entering data into databases, and other uses.
I've been using MS Office on Macs since 1990, and using the data entry form on numerous spreadsheets with database capability. I'm very frustrated that I can't find it.
Called MS Support twice already. First time I was put on hold and they hung up while I was on hold. Then they sent an email claiming the ticket was resolved. No joy at all. Called again later in the day, the tech almost knew what I was talking about, and after trying to get it to work, claimed that the entry form feature was only for Excel 2011. Unfortunately for her I have been using it since 1990.
So, how do we go about this? How do we find it or get it put back in? I can not accept that MS would remove that feature. So the feature must be there somewhere and we just have to find someone that knows what they are talking about.
Nov 28 2018 12:17 AM
Nov 28 2018 05:55 AM
Nov 28 2018 07:00 AM
Jan 02 2019 02:20 AM
I tried this on my mac excel but no joy
Jan 04 2019 01:14 PM
Feb 22 2019 03:09 AM
A relatively recent MAC user, but disappointed with Numbers and forced to sign up to Office 365 to get Excel. Instead I find a key feature in Excel, the Data Entry Form facilityis not available in the Office 365 provided by Microsoft for IOS.
What is additionally annoying is that 'Help' indicates that it is available - it isn't.
When will Microsoft fix this?
{Mac mini (Late 2012) IOS ver 10.14.3 (18D109) Excel Ver 16.22}
Mar 19 2019 08:30 PM
I'm also flabbergasted and disappointed about that missing feature!@null null
Looking for a solution I went to me free account at www.Airtable.com, imported there my excel spreadsheet as CVS format and with no delay have a data entry form for my existing data (and it's web-based!). Will export from Airtable once done.
This might be an easy solution for you, although we shouldn't have to...
Mar 20 2019 04:43 AM
Thanks @MaxDC for the suggestion. Since my post I've tried harder !
As a novice to extended use of Excel and VBA and who glazed over at Pivot Tables it was necessary to explore further and fortunately I've found a few useful formulae (SUMIFS etc) that combined with VBA have enabled a workaround for the Data Entry Form. I'm attempting to create an Excel alternative to MS Money, for which all the claimed alternatives I've tried over the years aren't.
And I'm slowly getting there - a fascinating and absorbing project as I approach 80 this year - and yes, I know I should get out more.
I'd welcome advice from anyone who has developed an Excel alternative to MS Money.
Jun 04 2019 08:57 AM
Pretty frustrating. My work-around is that Form exists as a function in Excel Mac 2011. So when I'm doing something that requires a form, I use that version. Although at some point soon, it will no longer work with the latest version of MacOS. If you are an Office 365 subscriber, I think you can still download and install Excel 2011.
Jul 15 2019 10:11 AM
@Acadia1532
If you like me in the UK and bought Office 2019 Mac, then return it for the full price.
On the ground of Purchase made on misleading Marketing, i.e Their manual still says you can use it though, while only from support call/pages you can find it's not.
Luckily Google Docs getting better and better and integrates with different CRM. SO in couple years this harvest finish.
Jul 15 2019 10:14 AM
Jul 18 2019 07:52 AM
Jul 18 2019 08:40 AM
I have no options for you in regards to Office 2019. I'm a Mac user. I found Office 2011 from a 3rd party, installed and updated it with the 14.7.7 Update. All of the Data Form & VBA features are available and work well in that version.
Jul 18 2019 08:42 AM
Office 2011 for Mac has all the Data Form and VBA features in it. I found it via a 3rd party, then updated it to the 14.7.7 update. Works fine.@Acadia1532
Jul 18 2019 08:49 AM
I have never used MS Money. However, my Office 365 does not have the Data Form and VBA features I need, so I downloaded Office 2011, then updated it with the 14.7.7 update. All the Data Form and VBA features exist in this version. From what i I see the description of MS Money, you can reproduce what you want using Office 2011. Good luck!@mikeretyred