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. 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

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