21-04-2021

Powerpivot For Mac Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Save relationship diagram view as picture

Start the Power Pivot add-in for Excel. Go to File Options Add-Ins. In the Manage box, click COM Add-ins Go. Check the Microsoft Office Power Pivot box, and then click OK. If you have other versions of the Power Pivot add-in installed, those versions are also. Excel 2016/2019 for Mac have many of the same basic analysis features that are listed above: PivotTables, slicers, charts, and basic import capabilities. They do not yet have Get & Transform or Power Pivot, but we are continually improving Excel on the Mac. Excel for Microsoft 365 for Mac offers some support for Power Query. Open Excel, Go to File – Options – Add-Ins; Select “COM Add-ins” from the “Manage” dropdown and click Go. Check the “Microsoft Power Pivot for Excel” checkbox and click OK. You will now see the Power Pivot.

Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.

Enhanced Edit Relationship dialog creates faster and more accurate data relationships

Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.

Install Powerpivot For Excel 2016

We have also added several usability goodies to the Edit Relationship dialog:

Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.
Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.
Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).

Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:

Power Pivot data model is no longer lost when working with hidden workbooks.
Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.
Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.

For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.

For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:

KB3114374—Office 2016 Excel update from December 8, 2015.
KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.

Try them yourself!

Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.

1.Excel for MAC does not support PowerPivot. Consequently, any pivot table having source data based on the Excel Data Model will be unfilterable if the spreadsheet is opened by a MAC user.

2. So will be any pivot table, that was created via the 'Import from Microsoft Access Database' option as Excel for MAC does not support OLEDB connections, either.

It does work for ODBC connections, though, so this may be your workaround...

3. Excel for MAC does not support Pivot Charts. As a result, they will no longer be interactive and change simultaneously with their source Pivot Table but remain static screenshot-like graphs

4.Pivot table value filters on Excel for Mac can only be applied to the left-most value field. There's no option to apply a value filter that has been placed in second or further position in the pivot table.

5. Field Calculation Types are limited on Mac. % of Parent Row Total and % of Parent Column Total are not available

6. If you're accustomed to using workbook and worksheet events for triggering your VBA routines, you're in for a disappointment - none of these will execute on MAC.

Powerpivot Excel 2016 Tutorial

7. Speaking of VBA codes, I cannot but mention that the VBA editor on Excel for Mac 2016 is in a very sorry state compared to its Windows counterpart:

(a) 'Properties' window is missing