Enabling Power View in Excel 2016

  • In Excel 2016, click on File -> Options -> Add-Ins
  • From the drop down select COM Add-ins and select Go…
  • In COM Add-Ins dialogue, if Power View for Excel is not selected, select the check box and click OK
  • Notice that enabling the Add-In does not provide the ability to create a Power View report from the ribbon

Here is how to enable Power View in the ribbon

  • Open Excel 2016
  • Click on File -> Options
  • Excel Options dialogue opens

  • Select Customize Ribbons from the left panel
  • In the right panel, under Main tabs, select the tab where you want to create a new group. I am selecting Insert tab
  • Click New Group button in the bottom of the right panel
  • From Choose commands from drop down pick Commands Not in the Ribbon option
  • From the list, pick Insert a Power View Report

  • With both Insert a Power View Report and New Group (Custom) selected, click on Add button
  • This adds Power View to the New Group (Custom) tab
  • Highlight New Group (Custom) and right click. Select Rename
  • Rename dialogue opens. Change Display name to Reports and click OK
  • Click OK in Excel Options dialogue
  • In the Excel workbook, from the ribbon select Insert. Notice Power View option is now available on the ribbon

6 thoughts on “Enabling Power View in Excel 2016

  1. after following the guidance it seems not to work for me also, however when closing excel and reopening it worked fine.

  2. Hi,
    I followed the steps described here above but when trying to execute Power View I am getting an error. This error is as follow:
    “Activate method of OLEObject Class failed”.

Leave a Reply to Anne M Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s