Microsoft Excel for Mac - PIVOT Tables

Question

Hello Everyone,

I am using a Microsoft Office for Mac.

I want to ask question regarding the pivot function for Microsoft Excel for Mac.

There is an option dialogue box missing from the existing interface he missing option is 'Add this data to the Data Model'.

I have been trying to add my existing worksheet with another worksheet under the same exel document. I read manuals and check the web and this suggest that I need to select/click on the option 'Add this data to the Data Model' in order to add multiple tables to create a pivot table report. I checked Mac version online manual for excel and it stated that the tab should exist in the Mac interface.

Am I missing something on the Mac version of Excel? My existing Mac excel is currently updated. 

My excel is running at Version 16.6.6 - 190114

My notebook is running MacOS Mojave (10.14.2) 

Please advice. Thank you.

Answer 1

I agree that they could have done better. However, I want to give credit where I think credit is due.

When Office 2016 first came out the code base was the same as Office 2011 for Mac. It was a distinctly different code set from Office for Windows. I hated it. I think the first general release build was simply the worst commercial software I had ever used. It crashed. It had bugs. It barely worked at all. I was telling users here in the forum to complain directly to Microsoft's Satya Nadella about how neglected the product was.

Apparently, all our complaints resulted in sweeping changes. During the 2016 product cycle Office, and Excel in particular, underwent a complete remake. They went from 32-bit to 64-bit. The entire code base was abandoned and replaced with the same code base as Office for Windows Word, Excel and PowerPoint. The Visual Basic Editor was rebuilt from scratch (and is still not quite done in 2019). On the Mac side, support for automation via JavaScript and Objective-C was added to AppleScript support. Crashes are practically non-existent. I have used Microsoft Office since 1985 and it has never been as stable as it is today,

I find the number of previously unsupported features that are now supported astonishing considering the short time span since the code base was switched over. The very latest formulas are now supported in Excel - the latest ones being the stock formulas. In Excel 2019 for Mac we now have flash fill, pivotcharts, slicers for tables & PivotTables and PivotCharts, built-in SQL Server ODBC driver, and many many more features.

I think Excel for Mac has undergone the most dramatic positive change of any software I have ever used, and it is evident that Microsoft is continuing to bring it up to par with Excel for Windows. The last remaining frontier is the power tools and accompanying data model piece, which is an enormous amount of coding to work with on a different operating system. They're doing it now! Yay!

While I lament that Office for Mac got way behind development of Office for Windows, I am delighted to see the amount of progress that has been made in a very short period of time. Hence, my advice to nudge the developers to keep at it by giving the feature a vote of support in the UserVoice forum.

Answer 2

Hi LIM ,

I am Vijay, an Independent Advisor. I am here to work with you on this problem.

You should upgrade your MS Office to latest production version which is 16.21 and then check.

Do let me know if you require any further help on this. Will be glad to help you.

Answer 3

Dear Vijay,

Thanks for your help and advice. 

I tried to update my excel but could not upgrade to 16.21 (see screenshot).

Is there a website where I could manually download the update? thanks

LIM

Answer 4

For manual downloads of Office - https://support.office.com/en-us/article/update...

Answer 5

Hi Vijay,

I had visited the office website and performed a manual download. My office suite has been upgraded to 16.21.1

Still the problem persist - on excel I can't add multiple pivot table from two worksheet (located in same file).

My office installed in Mac is a retail license registered. 

Please advice. 

Thanks.