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
- Make sure the pivot table is connected to a data table.
- Update the data table by adding new rows or modifying existing ones.
- Refresh the pivot table by clicking on the "Refresh" button in the "PivotTable Tools" tab or by pressing F5.
- The new data will be reflected in the pivot table.
Method 2: Use the "Add Data" button
- Select the pivot table.
- Go to the "PivotTable Tools" tab in the ribbon.
- Click on the "Add Data" button in the "Data" group.
- Select the new data range or table that you want to add to the pivot table.
- Click "OK" to add the new data to the pivot table.
Method 3: Use the "PivotTable Fields" pane
- Select the pivot table.
- Go to the "PivotTable Fields" pane (usually located on the right side of the screen).
- Click on the "Add" button at the top of the pane.
- Select the new data range or table that you want to add to the pivot table.
- Drag and drop the fields from the new data range into the pivot table fields pane.
- Adjust the layout and settings as needed.
Tips:
- Make sure the new data is in a format that is compatible with the pivot table, such as a table or range of cells.
- If you're adding new data to a pivot table that is already filtered, the new data will be filtered based on the existing filter settings.
- You can also use the "PivotTable Options" button in the "PivotTable Tools" tab to set options for how the new data is added to the pivot table, such as whether to update the pivot table layout or not.