Now, just imagine if you add data to your source sheet every day you have to update source range every day.And, if you do that more than one time in a day, it’s a mess.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
By applying a table in data source you don’t have to change the source of your pivot table again and again.
Whenever you add new data, it will automatically increase pivot table range.1.
If you add new records, or delete records, or edit the existing data, the pivot table doesn’t show the revised data right away.
To keep the pivot table up-to-date, you have 3 choices: Another way to update is to set the pivot table to refresh when you open the file that it’s in.