If additional rows are added to the source data of a PivotTable, what must be done?

When additional rows are added to the source data of a PivotTable, the appropriate action is to refresh the PivotTable. However, if the data range that the PivotTable is set to analyze does not automatically include these new rows, then it's necessary to change the data source to encompass the updated range.

The PivotTable is based on a specific range of data when it is first created. If new data rows are added outside this initial range, the PivotTable will not recognize this new information until the range is modified. By changing the data source, you can redefine the scope of the data that the PivotTable analyzes to include the new rows, which allows the PivotTable to reflect the most current data in your reports and analyses. This maintains the integrity of your data insights by ensuring they are based on the entire dataset, including any updates.

In summary, when the source data changes in a way that affects the original range reference used in the PivotTable, adjusting the data source is essential for accurate reporting.