How to enable Power Pivot data analysis for Excel if it is missing?

Here’s a question from a reader:

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.Looks like Power Pivot is missing in my system, as i don’t see it in my Excel 365 installation. How can i add it to Excel?

Show the Power Pivot tab in Excel 2016 and 2013

To enable Power Pivot in Microsoft Excel, proceed as following:

  • 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

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 Microsoft Excel.
  • Hit File.
  • From the left hand side bar, 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.
  • 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 it), working with Pivot Tables and so forth.Excel_PowerPivot

Removing the Power Pivot menu tab

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 🙂