Because the source data is a specific range – not a dynamic range or named table, it does not adjust automatically when new data is added.You can adjust the source range, so it includes the new data, but a better solution is to create a table or dynamic range, and base the pivot table on that.Any time you close then re-open the file, the pivot table will be refreshed.
Many people have the idea that building a pivot table is complicated and time-consuming, but it's simply not true.
Compared to the time it would take you to build an equivalent report manually, pivot tables are incredibly fast.
Follow these steps, to find the source data for a pivot table: On the worksheet, behind the dialog box, you can see the source range, surrounded by a moving border.
In the screen shot above, you can see that the source data range ends at row 9, and new data has been added in row 10.
If you have well-organized source data, you can create a pivot table less than a minute.
Here's how: To minimize problems down the road, always use good quality source data, organized in a tabular layout.After you create a pivot table, you might add new data, or change the existing data.When you refresh the pivot table, it might not show all the new records, or pick up the changes.It would be nice if a pivot table automatically updated, whenever its source data changes, but unfortunately, that doesn’t happen.If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised data right away.Do you know you can group dates in pivot tables to show the report by week, month or quarter?