locked
PowerPivot in excel 2010 SharePoint 2010 not manually refreshing RRS feed

  • Question

  • When I set PowerPivot to refresh on a timer job it works.  When click manual refresh it does not work and I get no error messages.  

    I understand that the two are distinct from each other. The Excel/PowerPivot 2010 manual refresh uses VertiPaq  so whats wrong with it? How do I trouble shoot this issue? 

    Thank you

    Sunday, January 12, 2014 7:16 PM

Answers

  • Hello,

    Interactive data refresh is only available for workbooks that created in Excel 2013. If we try to refresh an Excel 2010 workbook, Excel Services displays an error message similar to “PowerPivot Operation Failed: The Workbook was created in an older version of Excel and PowerPivot cannot be refreshed until the file is upgraded”. 

    In addition, here is a good article about troubleshooting PowerPivot Data Refresh for your reference. Please see:
    Troubleshooting PowerPivot Data Refresh: http://social.technet.microsoft.com/wiki/contents/articles/3870.troubleshooting-powerpivot-data-refresh.aspx

    Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, January 21, 2014 2:40 AM
    Moderator