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.
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
On the server that is running SharePoint Products, click Start, point to Administrative Tools, and then click SharePoint Central Administration.
Click Shared Services Administration, click Excel Services, and then click Trusted Data Providers.
Click Add Trusted Data Provider.
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.