Is there a way to update the pivot table as data is added to the original worksheet?

Is it possible for a pivot table to automatically update as data is added to original spreadsheet? I need to add data rows to my spreadsheet almost daily...will I need to redo the pivot table each time?

Thanks!

Hi,

create a named range for your source data. If you make the range a dynamic one, it will automatically adjust to new rows of data.

For a table from column A to column M, use a formula like this to create a name called DataTable

=Sheet1!$A$1:INDEX(Sheet1!$M:$M,COUNTA(Sheet1!$A:$A))

Build your pivot table based on the range name =DataTable instead of the absolute cell addresses =$A$1:$M$100

Then, whenever you click you refresh button on the pivot table, the new rows will be included.

hth