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

1

  • Select Options

2

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

3

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

4

Once we have done with all the steps above, we can see a new Tab added to the Excel Client by the name “POWERPIVOT”

5

When you click on this Tab, you can see extended Functions offered by this Plugin.

6

We will revisit this Plugin again in one of my upcoming articles and see it in action.

Hope you find it helpful.

Advertisements

One thought on “SharePoint 2013 : How to enable PowerPivot Excel Plugin for Excel 2013

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s