Thanks for the suggestion and for the support of this feature. If you meant to vote for the Data Form, which is different than VBA UserForms, please change your vote to that suggestion instead. From reading the comments on this one, it seems that some clarification was needed.
I updated the title and description for this one and we’ll continue to monitor for comments and votes.
Here’s the link to the Data Form suggestion – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/17930662-restore-data-form-functionality
Steve K [MS Excel]
In response to Rob, this is common with a lot of companies. Just look at the camera industry. A new camera is developed which has all the functions you need and within a couple of years a new version is brought out With some functions missing. This is endemic in our society today and it is killing the planet. It also loses customers. I have stayed with v2011 as it is the full version. Excel 2016 and 2019 are dumbed down versions and as such are scamming the customer. We should have our money refunded.
This is why Apple computers have a very small share of the commercial market. Even in architect’s offices where graphics are important Windows based machine are used. Apple limits what programs can be run, provides some software (Numbers, Pages, Contacts, Mail) all of which is pretty basic and they wonder why they don’t penetrate the commercial market. Linux does better.
This feature should be added to Excel 2016 as well as newer versions. People who bought 2016 thought they were buying an UPGRADE on 2011 but were scammed. If this is not possible then we should be able to get a FREE upgrade to the current version when it includes the various features removed in 2016.
Pigs will fly before any of this happens.
It has to be said that the main reason why Apple never had a larger share of the market was due to the simple fact that their own versions of Office (and other software) were toys compared with the real thing. Microsoft has always had a strong commercial following and it could easily “command” the Apple community as well by making the full version of Office available “on a Mac “. Not doing so encourages Apple users to use software such as OpenLibre which has a macro facility - not wonderful but better than what MS are offering at present.
I agree - profit is the driver in any organisation - but not at the cost of losing custom. This feature is central to the way Excel is used by many companies and Microsoft will lose custom on this one.
It's been three years... I think the reason is either
1. Microsoft deliberately down grade software designed to run on Apple equipment
2. Microsoft are incapable of producing a version which runs on Apple equipment
3. Apple have made it difficult or expensive to to make this happen
4. Microsoft want you to buy the 365 version and make money on the license fee
5. other (you choose your favourite conspiracy theory)
The bottom line is Microsoft are charging full price for a crippled version not much better than Apple's Numbers (which costs a whole lot less). Microsoft are clearly not interested in its customer's requirements.
Well done - congratulations you have joined the growing army of Microsoft independents! MS really do need to reconsider their policies or they will continue to loose custom to other software developers.
I moved to Apple and then to Linux (because Apple doesn’t have adequate “Office” software) and now use LibreOffice.
Crigou is quite right - my office in the UK (a very large architectural practice) would not even consider Apple systems. They didn’t meet the stringent requires required and failed on software quality, networking and stability.
Try LibreOffice - free software, runs on any platform and I am told is as good as if not better than MS Office.
As a Mac user who is using Excel for entering Parish Records onto a database (FreeReg) I shall be moving over to LibreOffice spreadsheets when Mojave arrives.
Microsoft lost my custom with their hopeless updates system five years ago, and now they lose me on everything else.
In response to: “It seems to be that MS Excel neither wants nor cares to reimplement UserForms for Mac users. Unwise on their part, as more and more offices are using 365 on Mac platforms...at least that's been my experience.”
Yes - in the process of dumbing down their software so that it works on all platforms they are loosing custom to OpenLibre which does have a viable macro system. Is this the beginning of the end for Microsoft? Many companies my moving over to Unix based systems such as Linux and Apple, so it could easily happen.
Microsoft are I think guilty of mis-selling their product. Therefore They would be liable in the UK for prosecution. Time to pass this one to the trading standards authority.
I believe all customers that bought this crippled useless piece of software should either be given a free upgrade to the next working version or given their money back in full. The release of this product was dishonest - and not fit for purpose. It was in fact a scam.
Microsoft is not alone in having to pander to the huge pressures of releasing new versions to keep up with the opposition. But it is unforgivable to release a new "updated" version that actually does LESS than the previous one. Customers buy the new version on the belief that it is better than the previous and the fact is that this version is an enormous scam. Nowhere in the usual pre-release hype did it say "we've deleted the entire VBA functionality"
To correct this monstrous error MS should offer a "downgrade" to version 2011 immediately. They will loose customers otherwise.
I have just noticed that my post back in May (?) had a typo in it which makes the message a little obscure. I suspect the spell checker did the dirty on me with a surreptitious change...
The second para has the phrase "dumping down" in it. This of course should have read "dumbing down" that is to make something simple but useless.
I believe LibreOffice has a macro language if anyone is interested in a better product. I haven't checked it out yet.
This version of Excel is a complete joke. The ability to create useful macros and userforms is non-existent. Is Microsoft going to give us our money back? This product is not much better than the original spreadsheet - VisiCalc (saw it demo'd in 1978/9).
What really annoys me is the amount time and resources spent on "dumping down" the product so that the emoji fans can have their fix. This is no longer a professional product worth using in the office (or anywhere else).
Now that the 2019 version is out are we going get a free copy (having bought the crippled 2016 version)?
I don’t think so.