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.
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.
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.
Data models in Excel 2013 cannot be downgraded to data models in Microsoft Excel 2010.