Enabling Power View in Excel 2016

4 comments
  • 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

4 comments on “Enabling Power View in Excel 2016”

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s