Turn on Power View in Excel for Windows

Though the Power View button in the Reports group has been removed from the ribbon in Excel 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. To turn on Power View, follow the steps below.

In the sections below, you'll learn how to customize the ribbon and turn on the Power View add-in.

Enable services

  1. On the File tab, choose Options > General.

  2. In the Office intelligent services section, turn on Enable servicesif it is not already enabled.

  3. Exit and restart Excel.

Customize the ribbon

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

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

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

    Customize the ribbons box in Excel
  4. After choosing both Insert a Power View Report and New Group (custom), 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), click the Rename button and—in the Display Name box—enter "Reports" or a similar group name of your choosing.

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

Turn on the Power View add-in

Click the ribbon button that you added by following the instructions above.

The first time you insert a Power View sheet, Excel

Custom Pivot View button and dialog turning on the add-in in Excel

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.

×