PowerPivot for SharePoint Installation (SharePoint 2010)

PowerPivot for SharePoint is a collection of server components that provide query processing and management control over PowerPivot workbooks that you publish to SharePoint. Services include the Analysis Services engine and PowerPivot System Service.

Note

For information regarding SQL Server 2012 SP1 and installation with SharePoint Server 2013, see the following:

Analysis Services provides server-side processing for Excel workbooks that contain PowerPivot data. PowerPivot System Service works alongside Analysis Services, adding SharePoint integration, load balancing and connection management. PowerPivot for SharePoint extends Excel Services by pairing its large scale data processing capability with the data rendering services that Excel provides. 

To install PowerPivot for SharePoint, use the SQL Server 2012installation media. 

For instructions on advanced deployment scenarios, see Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint and Deployment Checklist: Scale-out by adding PowerPivot Servers to a farm.

In This Section

Hardware and Software Requirements (PowerPivot for SharePoint and Reporting Services in SharePoint Mode)

PowerPivot for Excel Installation

Install PowerPivot for SharePoint

Install the Analysis Services OLE DB Provider on SharePoint Servers

Install ADOMD.NET on Web Front-End Servers Running Central Administration

Install ADO.NET Data Services to support data feed exports of SharePoint lists

Install PowerPivot from the Command Prompt

Uninstall PowerPivot for SharePoint

Repair PowerPivot for SharePoint

Initial Configuration (PowerPivot for SharePoint)

See Also

Concepts

PowerPivot Configuration in Central Administration