How to add new data to pivot table

To add new data to a pivot table in Excel, you can follow these steps:

Method 1: Update the underlying data table

  1. Make sure the pivot table is connected to a data table.
  2. Update the data table by adding new rows or modifying existing ones.
  3. Refresh the pivot table by clicking on the "Refresh" button in the "PivotTable Tools" tab or by pressing F5.
  4. The new data will be reflected in the pivot table.

Method 2: Use the "Add Data" button

  1. Select the pivot table.
  2. Go to the "PivotTable Tools" tab in the ribbon.
  3. Click on the "Add Data" button in the "Data" group.
  4. Select the new data range or table that you want to add to the pivot table.
  5. Click "OK" to add the new data to the pivot table.

Method 3: Use the "PivotTable Fields" pane

  1. Select the pivot table.
  2. Go to the "PivotTable Fields" pane (usually located on the right side of the screen).
  3. Click on the "Add" button at the top of the pane.
  4. Select the new data range or table that you want to add to the pivot table.
  5. Drag and drop the fields from the new data range into the pivot table fields pane.
  6. Adjust the layout and settings as needed.

Tips: