Provide all the options that are available to Windows users
MAC users are severely limited with what they can do in Excel compared to Windows users. I am doing an Excel course and creating a Pivot Chart is not an option for me nor do I have the option to create a PowerPivot as my classmates who use Windows PCs. All that needs to be done is to make things comparable. What you do for one- Windows PC users, you do for the other- Mac users. Level the playing field so to speak.
It's not only about Pivot Tables. All Mac Excel applications and features need to be updated and be comparable to all Windows Excel applications and features.
Thank you for posting and voting for this. Unfortunately, this suggestion is too broad, so I encourage you to vote for the specific features that you’d like to see. We have been working hard to add features to Excel for Mac that have been available on Windows, and make sure that new features are available on both platforms.
Please go to this link to see all the requests that have been completed, including Pivot Charts – https://excel.uservoice.com/forums/304933-excel-for-mac/filters/top?status_id=1406092
Thanks – Steve K [MS Excel]
6 commentsComments are closed
I was glancing at how to do data models in Excel and it mentioned something about the modeling relationships (PK,FKs) driving the Pivot table functionality.
So if you don't have pivot tables, I presume that also means no data relationship modeling.
I totally agree.
This includes all the options for the 'Quick Access Toolbar'. I use 'open' constantly in Microsoft Excel, Word, Powerpoint on the PC applications at work. It is much easier than the current need to use File > Open Recent & then find the file.
It would also be great to add the 'pin' option to this whole process as well. It is another great feature of the PC versions. Currently, this doesn't even show up until you click on 'more' at the bottom of the Find > Open Recent list.
I agree, this difference has required me to buy VMware so that I can run excel for windows on my mac. this is quite cumbersome.
I fully agree, the amount of hassle that comes with having a mac purely from the office suite (especially excel) is ridiculous. The only case for not using Google Sheets is currently the fact that receiving customers are still in legacy-mode and uses various versions of excel.
You can access Pivot Charts if you upgrade to Excel for Mac v16.6 or higher - you will need Office365 subscription, but it is available. As for Power Pivot/Query etc, MS needs to extract their digits and get on with it!