"3241607174" error code when you try to enable a scheduled data refresh on an Excel 2013 workbook that is stored in SharePoint Server 2010

Symptoms

Assume that you upload a Microsoft Excel 2013 workbook to a PowerPivot Gallery on a Microsoft SharePoint Server 2010 server. When you enable a scheduled data refresh on the workbook, you receive the following error message from the SQL Server Analysis Services instance:
Error Code: 3241607174

A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook, file File Name.

Cause

This issue occurs because Excel 2013 contains upgraded data models that cannot be scheduled for a data refresh in PowerPivot Gallery on a SharePoint Server 2010 server.

Workaround

To work around this issue, you must upgrade SharePoint Server 2010 to Microsoft SharePoint Server 2013. After the upgrade, you can schedule a data refresh for an Excel 2013 workbook in a PowerPivot Gallery on a SharePoint Server 2013 server.

More Information

Data models in Excel 2013 cannot be downgraded to data models in Microsoft Excel 2010.
속성

문서 ID: 2761246 - 마지막 검토: 2012. 10. 31. - 수정: 1

피드백