- 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”
DId that but nothing happen when I click on Power View
Did you ever resolve this?
You need to have underlying data for Power BI to work
after following the guidance it seems not to work for me also, however when closing excel and reopening it worked fine.
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”.
Excellent ! Worked Perfectly for me.
Very straight to the point
Thanks a lot !