Error when clicking "manage powerpivot data" in Sharepoint RRS feed

  • Question

  • I have set up a secure store service ID for powerpivot.

    Yet when i click a workbook and select "manage power pivot data" i get the following error:

    "SQL Server Analysis Services (PowerPivot) instance returned the following error: Error Code: 3239968790 Description: The embedded PowerPivot data in the workbook cannot be loaded due to a version mismatch."

    Tuesday, October 23, 2012 4:37 PM


  • Hi Novak1984,

    Could you please elaborate your environment with more detail? If our SharePoint environment has the PowerPivot (SQL Server 2008 R2) installed, then by design it will only be able to render workbooks that were created with the client version of Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010.

    If our workbooks were created with newer version of the PowerPivot client (Microsoft® SQL Server® 2012 PowerPivot® for Microsoft® Excel® 2010), we will get this error message.

    Solution: Using the same PowePivot for Excel verison will solve this issue.

    Here is a similar thread about this topic for your reference, please see:


    Bin Long

    TechNet Community Support

    • Marked as answer by Elvis Long Thursday, November 1, 2012 1:23 AM
    Wednesday, October 24, 2012 9:11 AM