locked
Power pivot RRS feed

  • Question

  • Hello

    I have created a power pivot but am unable to see how to add new data so it can refresh the pivot tables and charts I have created? can you advise how I can do this?

    Thanks

    Jo

    Thursday, March 12, 2015 12:38 PM

Answers

All replies

  • Jo,

    It depends on how you added the data originally.

    If you added data directly to the Data Model, return to the Data Model to refresh it.

    From Excel, click the PowerPivot tab | Manage | Update All.

    Greg

    Thursday, March 12, 2015 6:46 PM
  • Hi Jo,

    At any time, we can click Refresh to update the data for the PivotTables in your workbook. You can refresh the data for PivotTables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, and many other sources.

    And we can set your workbook to refresh its PivotTable data automatically when you open it. Please refer to the link below to see the detail.
    https://support.office.com/en-nz/article/Update-refresh-data-in-a-PivotTable-d3f74ee2-0da7-4aef-8b2f-481bb2f18218

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, March 13, 2015 8:03 AM