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

Article translations Article translations
Article ID: 2761246 - View products that this article applies to.
Expand all | Collapse all

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: October 31, 2012 - Revision: 1.0
Applies to
  • Microsoft Excel 2013
Keywords: 
kbsurveynew kbprb kbinfo kbexpertiseinter KB2761246

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com