locked
update data probelem from Sharepoint List to PowerPivot. RRS feed

  • Question

  • I created a Powerpivot pivot table taking data from a SharePoint List.(Sharpoint List as data-feed)

    On publishing the excel sheet onto power-pivot gallery, if I make any modifications in the SharePoint List or add new data, then its not reflected into the excel worksheet.

    Any solution for this ?

    Monday, September 6, 2010 10:59 AM

Answers

  • This is not automatic in PowerPivot, you should schedule a data refresh when using SharePoint or do a manual refresh when using the Excel client, click the refresh button in the PowerPivot window and refresh the pivottable as well.
    Monday, September 6, 2010 11:32 AM