How to auto update data source range of pivot table

[Sean15]

Hi:

When I add new data to source data of pivot table, I have to also change data source range of the pivot table for pivot table to update. Is it possible to add new data and auto update data source range of pivot table? Hope this makes sense.

Sean

 

[JamesCanale]

The easiest way to get some of this done, is to "Format as Table" your data source. So when you point your pivot table to "Table 5" instead of A1:C33, the pivot table will resize to take on the new table size. Tables in excel are good at growing as you add lines to the bottom, or paste more lines to the bottom. It will not auto update however, you still have to refresh the pivot table. But you aughtn't have to change the data source anymore.