Excel For Mac Powerpivot

by



Excel 2016 for Windows introduced a powerful set of Get & Transform Data tools. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources. Today, we are excited to announce the first step in a journey to support Power Query in Excel for Mac.

Here’s a question from a reader:

  • I have Excel for Mac 16.16.17. I am trying to create a pivot table from a data group that has customer age, item bought, price & date. I can get the table to give me a count of items bought by age of customer (i.e 21,22,23,24 etc) but I want to create groups of ages - not just individual age (i.e. 20-25, 26 -30, etc.).
  • More aboutPower Pivot. Troubleshooting: Power Pivot ribbon disappears. In rare cases, the Power Pivot ribbon will disappear from the menu if Excel determines that the add-in is destabilizing to Excel. This might occur if Excel closes unexpectedly while the Power Pivot window is open. To restore the Power Pivot menu, do the following.
  • Excel 2016 for Windows introduced a powerful set of Get & Transform Data tools. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources. Today, we are excited to announce the first step in a journey to support Power Query in Excel for Mac.

Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting. I am wondering where can i find Power Pivot? How can i add it to Excel?

Power Pivot Excel Mac

Power query mac excelExcel For Mac Powerpivot

Power Pivot For Excel 365

Thanks for the question.

Fully agree that Power Pivot is a bery powerful tool, and looks like it is picking up quite nicely as the “brains” of the Microsoft Business Intelligence suite.

Showing the Power Pivot tab in Excel

Excel 2016 and 2013

Powerpivot
  • Open Excel.
  • From the left hand side, hit Options.
  • The Excel Options dialog will open.
  • Select Add-ins.
  • At the bottom of the dialog, in the Manage box, select COM Add ins.
  • Hit Go.
  • Select the Microsoft Power Pivot for Excel box.
  • Alternatively, you can use the same procedure to install Power Map, Power View.
  • Hit OK.

Excel 2019 / Office 365

Excel For Mac Powerpivot

Note: A far as i can tell, the Microsoft Data Analysis add-ins are now shipping as part of all Microsoft Office 365 subscriptions as well as Office 2019 Home, & Business and Home & student and Professional versions.

  • Open Excel.
  • From the left hand side, hit Options.
  • The Excel Options dialog will open. Now select the Data tab.
  • In the Data Options tab, check the Enable Data Analysis add Ins box as shown below.
Excel For Mac Powerpivot
  • Hit OK.
  • Back in your spreadsheet, you’ll notice the Power Pivot tab.
  • From here you can hit the Manage button to get started with acquiring external data (or refreshing ti), working with PivotTables and so forth.

Power Query Mac Excel

Removing the Power Pivot tab / addin

What Is Power Pivot Excel

If for some reason, you would like to deactivate Power Pivot in order to troubleshoot any issue, execute the steps above according to your software version, but make sure to uncheck the add-in.

Hope it helps 🙂