Jon Gallant

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

1 min read

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

Screenshot

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

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

Screenshot

  1. You will now see the Power Pivot tab

Screenshot

Share:
Share on X