Create a Power View sheet in Excel 2013

 Important    This feature isn’t available in Office on a Windows RT PC. Power View and Power Pivot are only available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013. Read Excel 2010 workbooks with Power Pivot don't work in some versions of Excel 2013. Want to see what version of Office you’re using?

It’s easy to create a Power View sheet in Microsoft Excel 2013.

  • On the Insert tab > Power View.

Sometimes the Power View icon is grayed out. If so, you may need to turn on the Power View add-in.

 Tip    It’s a good practice to work with Excel tables rather than just ranges of data. Before you insert a Power View sheet based on your data, create an Excel table.

 Note    If you open an Excel 2010 workbook in Excel 2013 and try to insert a Power View sheet, you may see the message that the workbook has a Power Pivot data model created using a previous version of the Power Pivot add-in. If so, you can upgrade the workbook so you can add a Power View sheet. However, you won’t be able to open the upgraded workbook in Excel 2010 after you upgrade it.

Read about everything you can do in Power View.

In this article


Start Power View the first time

The first time you insert a Power View sheet, Excel asks you to enable the Power View add-in.

  • Click Enable.

Power View requires Silverlight, so the first time, if you don’t have Silverlight:

  1. Click Install Silverlight.
  2. After you have followed the steps for installing Silverlight, in Excel click Reload.

Turn on the Power View add-in from Excel Options

If the Power View icon is grayed out on the Excel Insert menu, you can still turn it on.

  1. Go to File > Options > Add-Ins.
  2. In the Manage box, click the drop-down arrow > COM Add-ins > Go.
  3. Check the Power View check box > OK.

Connect a Power View sheet to external data

You can also create a Power View sheet connected to an external data model in Excel.

“Power View needs data to work with”

If the Power View Field List has the message Power View needs data to work with:

  1. Go back to the sheet that has data in your workbook and select the range of cells containing data.
  2. Insert tab > Power View again.

You have the option to create another Power View sheet or add the data to the sheet you already created.

Power View adds the range to the Field List and adds the data directly to the Power View sheet.

“Query execution failure”

If you’re seeing query execution failures when you try to work with Power View in Excel, it might be because you’ve installed the 32-bit (x86) version of Excel 2013.

Solution: Consider installing the 64-bit version of Excel 2013.

Silverlight is installed, but Excel says it isn’t

Maybe you’ve installed Silverlight, but you still see a message that you need to install it.

  1. Uninistall Silverlight (Control Panel > Uninstall a program).
  2. Reinstall Silverlight.
 
 
Applies to:
Excel 2013, Power View in Excel 2013, Power View in SharePoint Server 2013