Article ID: 2769345 - View products that this article applies to.
Assume that you use an Analysis Services source to create a PivotTable in Microsoft Excel 2013. You upload the Excel Workbook to a Microsoft SharePoint site. When you try to either refresh the PivotTable or filter the data in the PivotTable, you receive the following error message:
We cannot locate a server to load the workbook Data Model.
This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.
To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps: