Skip to main content
TechNet
PowerPivot for SharePoint 2010 Installation
 

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.

System_CAPS_ICON_note.jpg 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 SharePoint 2010 farm.

Install PowerPivot for SharePoint 2010

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)

PowerPivot Server Administration and Configuration in Central Administration