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

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

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

4) You will now see the Power Pivot tab