![how to toggle field list pivot tables in excel 2013 how to toggle field list pivot tables in excel 2013](https://sfmagazine.com/wp-content/uploads/2ExcelWebOnlyFigure5.png)
The next step is to click inside your pivot table so that the Pivot Table tools options appear in the ribbon toolbar, as shown here:įrom there, click Options in Excel 2010 or earlier, or Analyze in Excel 2013. As you can see, we now have 924 rows of data: Here's a shot of some of our additional data. In our case, we'll simply paste the additional rows of data into the existing sales data table.
#How to toggle field list pivot tables in excel 2013 how to#
In order to demonstrate how to update the data in your pivot table, let's look at the example we used in our lesson on How to Create A Pivot Table (link opens in a new window), where we summarized several months of sales data by different sales people in our team. Scenario: you have a pivot table containing sales data that needs updating with new data But data changes often, which means you also need to be able to update your pivot tables to reflect the new or changed data.
![how to toggle field list pivot tables in excel 2013 how to toggle field list pivot tables in excel 2013](https://contexturesblog.com/wp-content/uploads/2011/09/sortpivotcustomlist02.png)
When you create a new Pivot Table, Excel either uses the source data you selected or automatically selects the data for you. This lesson shows you how to refresh existing data, and add new data to an existing Excel pivot table.