Create a Power View sheet in Excel 2013
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.
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.
Power View requires Silverlight, so the first time, if you don’t have Silverlight:
Click Install Silverlight.
Tip Install Silverlight from Internet Explorer rather than other browsers.
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.
Go to File > Options > Add-Ins.
In the Manage box, click the drop-down arrow > COM Add-ins > Go.
Check the Power View check box > OK.
Connect a Power View sheet to external data
“Power View needs data to work with”
If the Power View Field List has the message Power View needs data to work with:
Go back to the sheet that has data in your workbook and select the range of cells containing data.
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.
Uninistall Silverlight (Control Panel > Uninstall a program).