How to Enable the Power Pivot Add-in in Excel 2016

It took me a few minutes to figure out how to get the Power Pivot Excel Add-in installed, so I figured I’d do a post to save you some time.

Instead of a download it’s actually already installed when you install Office 16, it’s just disabled. Let’s go ahead and enable it.

  1. Open Excel, Go to File –> Options –> Add-Ins

  1. Select “COM Add-ins” from the “Manage” dropdown and click Go.

  2. Check the “Microsoft Power Pivot for Excel” checkbox and click OK.

  1. You will now see the Power Pivot tab