SymptomsConsider the following scenario:
- You install Microsoft SharePoint Server 2010 Enterprise Edition together with Microsoft SQL Server 2008 R2 on a computer. Or, you install SharePoint Server 2010 Enterprise Edition together with SQL Server 2012 PowerPivot for SharePoint on a computer.
- You verify that the deployment is operational by uploading a PowerPivot workbook that is created by using Microsoft SQL Server 2008 R2 or by using SQL Server 2012 PowerPivot for Microsoft Excel 2010.
- You use Microsoft Excel 2013 to create a workbook that uses an advanced data model.
- You upload the workbook to the SharePoint Server 2010 farm and try to interact with the workbook in the browser.
Excel Services and PowerPivot for SharePoint 2010 load PowerPivot data models from a custom XML part in the workbook. Therefore, this technology is incompatible with internal connections that do not reference an MSOLAP provider (such as the connections that are used by Excel 2013).
Note PowerPivot functionality is not supported by Excel 2013 workbooks that use data models in SharePoint Server 2010 environments.
Excel Services and PowerPivot for SharePoint 2013 load Excel 2013 workbooks that use advanced data models and PowerPivot workbooks that are created in PowerPivot for Excel 2010.
Id. de artículo: 2755126 - Última revisión: 23 oct. 2012 - Revisión: 1