Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important:  Power View has been removed from the ribbon in Excel for Windows, however the interactive visual experience provided by Power View is available as part of Power BI Desktop, which you can download for free. You can easily import existing Power View reports to Power BI. While Power View is still available, you may need to update Microsoft Silverlight, as it is now turned off by default.  To turn on Power View, follow the steps below.

Enable services

  1. On the File tab, choose Options > General > Privacy Settings > click the Privacy Settings button.

  2. Next, in the Optional connected experiences section, check the Enable optional connected experiences option.

  3. Exit and restart Excel.

Customize the ribbon

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

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

    New Gtroup button in the Customizr Ribbon Excel options
  3. Next, select the Choose commands from option, click Commands Not in the Ribbon, choose Insert a Power View Report from the list, and click Add. You can use the Up/Down arrows to the right of the Main Tabs group to move the new group if needed.

    Customize the ribbons box in Excel
  4. With New Group (custom) selected, click the Rename button, and in the Display Name box enter the name you want for your Power View group, like "MyReports". To finish, click OK twice.

Rename button in Customize Ribbon dialog

Turn on the Power View add-in

The first time you insert a Power View sheet, Excel you'll be prompted to enable Data Analysis add-ins, so click Enable.

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

You may also be prompted to enable Silverlight. If you still receive a prompt after that, you might need to use registry keys to unblock Silverlight.

If you still have issues after that, you should consider moving to Power BI Desktop, as it is a much more feature rich application.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!