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?



    Thursday, March 12, 2015 12:38 PM


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.


    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.


    Charlie Liao
    TechNet Community Support

    Friday, March 13, 2015 8:03 AM