SharePoint 2013 : How to enable PowerPivot Excel Plugin for Excel 2013

While working with SharePoint 2013 BI Stuff you must have come across an essential component called “PowerPivot Reports”.

On the same lines it is worth to know about an Excel Plugin called “PowerPivot Excel Plugin” that further complements the designing of PowerPivot Style Reports using diversified range of Data Sources.

In this article we will see how can we enable “PowerPivot Excel Plugin” for Excel 2013 and in subsequent articles we will also see how to leverage this Plugin while designing reports based on different data sources like SSAS Cube, SQL Server and so on.

• Launch Excel 2013
• Select Blank Workbook

• Select Options

• Select Add-Ins
• Select COM Add-Ins
• Click in on the Go… Button to look up all the available plugins

•  Out of the available plugins look for “Microsoft Office PowerPivot for Excel 2013” and Select it
• Click OK

Once we have done with all the steps above, we can see a new Tab added to the Excel Client by the name “POWERPIVOT” When you click on this Tab, you can see extended Functions offered by this Plugin. We will revisit this Plugin again in one of my upcoming articles and see it in action. Hope you find it helpful.

by Prashant Bansal via Everyone's Blog Posts - SharePoint Community