Turn on Power View in Excel 2016 for Windows

The Power View button in the Reports group has been removed from the ribbon in Excel 2016 for Windows. The interactive visual experience provided by Power View is now available as part of Power BI Desktop. All the functionality of Power View is available and will continue to be supported in Excel 2016. To turn on Power View, follow the steps below.

First, you'll need to customize the ribbon, and then turn on the Power View add-in.

Customize the ribbon

  1. On the File tab, > Options > Customize Ribbon.

    File > Options > Customize ribbon
  2. Under Main Tabs, click the tab where you want to add the new group, and then click New Group.

    New Gtroup button in the Customizr Ribbon Excel options
  3. Under Choose commands from, click Commands Not in the Ribbon, and then in the list, pick Insert a Power View Report.

    Customize the ribbons box in Excel
  4. With both Insert a Power View Report and New Group (custom) selected, click Add, and then move the New Group (custom) to where you want it on the ribbon.

    Add button in the Customize Ribbon dialog in Excel
  5. Click New Group (custom), > Rename, and then in the Display Name box, type Reports or the group name you want.

    Rename button in Customize Ribbon dialog
  6. Click OK twice.

Turn on the Power View add-in

The first time you insert a Power View sheet (click the ribbon button you added), Excel prompts you to turn on the Power View add-in.

Custom Pivot View button and dialog turning on the add-in in Excel
  • Click Enable.

Note:  The new option, File > Options > Advanced > Enable Data Analysis add-ins: Power Pivot, Power View, and 3D Maps activates the COM Add-ins, but will not add the Power View command to the Insert tab. To see the Power View command in the ribbon, you need to follow the steps in Customize the ribbon section above.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.