"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.
Properties

Article ID: 2761246 - Last Review: 10/31/2012 05:35:00 - Revision: 1.0

Microsoft Excel 2013

  • kbsurveynew kbprb kbinfo kbexpertiseinter KB2761246
Feedback