SharePoint 2013 - How To Enable PowerPivot Excel Plugin For Excel 2013

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

Along the same lines, it is worth reading to learn about an Excel plugin called “PowerPivot Excel Plugin”, which further complements the designing of PowerPivot Style Reports, using a diversified range of data sources.

In this article, we will see, how we can enable “PowerPivot Excel Plugin” for Excel 2013 and in subsequent articles, we will also see how to leverage this plugin, while the 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 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 are done with all the steps, given above, we can see a new tab is added to Excel client by the name “POWERPIVOT”.



When you click this tab, you can see the 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.