Why is Excel 2016 for Mac so bad?

Anonymous
2016-08-27T19:22:32+00:00

I'm wondering what people think - Excel 2016 for Mac seems to be so bad that it must be intentional. Am I wrong? Is Microsoft still waging a low-grade war on Mac users by making their products subtly awful on a Mac? Is it just that they have really bad developers? Is it that the developers are good but the management somehow makes them do terrible work? Is it that whoever is in charge of designing Excel for Mac has an ex who uses it for his/her job and this person has devoted his/her life to making his/her ex's life bad in confusing ways? Has a nefarious actor infiltrated Microsoft in order to make their products just bad enough that companies will continue to use them but their awfulness will create a small long-term drag on the US economy? Answers would be appreciated. Thanks!

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

114 answers

Sort by: Most helpful
  1. Anonymous
    2017-06-28T19:58:43+00:00

    LOL. Yep, June 2017 and it's still super bad. I'm going with all of the above for the reasoning behind this. There's not really any other answer! I am currently doing 90% of my work on my new mac, and then having to finish each spreadsheet on my 10 year old PC because, even though it is as slow as molasses, all the features in Excel work. Sure is fun.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-06-27T15:29:58+00:00

    Well, I love the conspiracy theories you have postulated. I suspect the problems are the result of much more mundane realities. What follows is my own private conjecture about the situation.

    MVPs get to meet the Microsoft Office for Mac team occasionally, along with the Office for Windows teams. Size matters. There are thousands of Office for Windows employees and a relative handful of Office for Mac employees. I think the #1 core problem is there simply aren't enough programmers and program managers at Microsoft who know how to write code for Macs. The door is always open. They ask us to encourage anyone who wants to work for the Office for Mac team to apply to Microsoft. There is a world-wide shortage of programmers in general, and there's a critical shortage of programmers who know how to program on the Mac. Finding and keeping (especially keeping) programmers and good managers seems to me to be the #1 problem.

    Then there's the general opinion that the web and mobile devices rule and the desktop is dead. No one wants to program for desktop applications any more. iOS and Android is where the action is. You would think Windows Phone would be attractive to developers who know Windows, but not so much.

    Email is considered a dinosaur. Who wants to have on their resume they helped write Microsoft Outlook? Sure, it's used by millions of people every day, but text messages are the rule today.

    I can't rank #2 #3 #4, etc. There are just some other factors that seem to come into play.

    * Mac OS. It changes like the wind. Trying to keep Office running on each and every update that comes down the pike is a huge problem. Sometimes I think Apple deliberately messes with Mac OS to screw Microsoft. For example, the next item in my list...

    * Sandboxing. Microsoft adopted sandboxing to keep Office for Mac "Mac-like" and because Apple won't let Microsoft sell Microsoft Office in the App store unless Microsoft goes along with Sandboxing. Sandboxing crippled Microsoft Office. If I were looking for criminal behavior of a monopolist, I'd be going after Apple about sandboxing and their strong-arm tactics about getting apps into the App store.

    * Cost containment. In a sense, maintaining Office for Mac and Office for Windows is duplication. You have to invent everything twice. Since Office for Mac sales are less than Office for Windows, Microsoft is keen on keeping the cost as low as possible. This, combined with not enough staff, is a big problem. Expensive to make features that don't get a lot of use are left out of Office for Mac. For example, Object Linking and Embedding (OLE) is very limited on the Mac. 

    Which results in a very weak version of Excel for Mac. I consider it to be only about 1/3 done. If and when the promised Visual Basic Editor ever comes along, then I'll consider it to be 2/3 of the way. When the missing SQL and data components finally make their way to the Mac, then I'll say it's complete.

     I am shocked you have become a Microsoft  Apologist.

    Microsoft should get out of the notion to compartmentalize customers. customers are customers, are customers Period. I would express my opinion but I've been warned if I express my opinion one more time I may be banned from the forums.

    _________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2018-09-15T04:19:13+00:00

    I really did not like MS forcing me to upgrade for Excel 2011 to 2016. having done so I amn doubly resentful. Not only is it a whole lot more expensive but its is terrible. I am on a Mac and if MS think this is going to forces me back into Windows they are very mistaken. It merely confirms my original decision to leave Windows. Incidentally I have to have (not for much longer!) Win10 on my Mac (in Oracle VirtualBox) and as an OS it sucks. 

    1. Auto-recover used to be in a folder of your choice. Now it is somewhere in the MS cloud. I couldn't find it and as soon as you aren't on line guess what ? No auto-recover. That sucks. I now have to remember to save every 5 minutes just like in the late 80's. That sucks. Two days ago I closed a file by mistake and lost 2 hours work. Auto-Recover, allegedly on, was wholly useless. That sucked.
    2. What propelled me into this whinge is I am working on a big spreadsheet and trying to select big blocks of data. Dragging the cursor off the edge of the screen doesn't work properly any more. Sometimes it does. Sometimes it doesn't. It wastes my time and it sucks.

    3.Writing formulae is a whole lot harder. The cursor cannot easily be  placed on a cell directly adjacent  to the cell you are trying to write a formula for. That wastes my time and it sucks.

    1. Opening files is a whole lot more clunky. It is probably 2 or 3 more clicks than in Office for Mac 2011 (which I had no complaints about). That sucks. I wish I could go back. 
    2. With the latest update when you click "Save as" Excel now adds "Copy Of" to the front of the file name. That wastes my time and it sucks.

    There are other issues too. But heck, I am meant to be working, not whinging.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2018-09-02T11:44:29+00:00

    'Embedded Objects other than Word or Excel files is not supported on Macs. Other file types cannot be embedded on a Mac & if embedded on a PC they cannot be opened on a Mac.'

    Unbelievable. How dreadful this software is for a Mac user. How can you actually charge money for software that does not work? Absolutely shameful .

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  5. Anonymous
    2018-06-10T21:08:48+00:00

    Hi mintymiller,

    Good point. While this forum lets us jawbone, there is a UserVoice forum Microsoft uses to receive feature requests. For Excel, it is

    Excel for Mac

    Live previews is one of my own high priority wishes, yet I don't even see a suggestion for it. If you put a suggestion for Live previews and reply here with the link I will certainly vote for the suggestion and make comments encouraging implementation.

    Same thing with Find All. Make a feature request.

    You can use VBA to Find All

    https://www.thespreadsheetguru.com/the-code-vault/2014/4/21/find-all-instances-with-vba

    I will, but one can’t but wonder why on earth these features are not already in there? What prevents MS from giving Mac users features that Windows users have enjoyed for years?

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments