Automatically refresh power pivot data without sharepoint RRS feed

  • Question

  • Dear all,

    I have read many sources on the web and still can't find the answer on my question.

    My partner uses PowerPivot for Excel 2010 spreadsheets but does not have Sharepoint 2010. How could I provide the powerpivot data is refreshed on excel file open - without to publish it to the Sharepoint? Can we expect some solution in this way in further versions of PowerPivot?

    Thanks for your answers,

    Regards Marko

    Tuesday, April 10, 2012 6:54 AM


  • Hi,

    As of now, you can only schedule the refresh the power pivot data after it got uploaded to share point. You need to use "refresh" button inside power pivot window to refresh inside Excel.  You can't automatically refresh when excel  is opened.

    We can expect the solution in the later versions. You can try to log a request in Microsoft connect so that they might consider your proposal.


    Please mark as answer if helpful

    • Proposed as answer by Darren GosbellMVP Wednesday, April 11, 2012 4:22 AM
    • Marked as answer by Challen Fu Wednesday, April 18, 2012 10:26 AM
    Tuesday, April 10, 2012 8:18 AM