Resolve problems working with Excel workbooks and SharePoint server

Last Update: 3/6/2017

TFS 2015 | TFS 2013

Before you use Excel 2010 to publish a workbook to a server that is running Microsoft Office SharePoint Server 2007, you must first install MSOLAP.4 on the server that is running SharePoint Products. To install MSOLAP.4, you add it to the list of approved providers in Excel Services.

Required permissions

To perform this procedure, you must be a member of the Administrators group on the server that hosts the SharePoint web application. For more information about permissions, see Permission reference.

To install MSOLAP.4

  1. On the server that is running SharePoint Products, click Start, point to Administrative Tools, and then click SharePoint Central Administration.

  2. Click Shared Services Administration, click Excel Services, and then click Trusted Data Providers.

  3. Click Add Trusted Data Provider.

  4. In the Provider ID box, type the following code:

    Provider ID = MSOLAP.4  
    Data Provider Type = OLE DB  
    Description = Microsoft OLE DB Provider for OLAP Services 10.0.  
  5. Click OK.