dynamically update pivot table data source

  • Thread starter Thread starter puzzanch
  • Start date Start date
P

puzzanch

I am trying to determine if there is a way to dynamically
update the data source underlying a pivot table. For
example, I have a data sheet that grows by one year each
month and this sheet populates a pivot table. Each time I
add a new row, I have to redefine the source data range
for the pivot table. Can this action be done
automatically? I have seen something like this to update
graphs using the series function... just not for pivot
tables.

Thanks in advance.
chaz
 
-----Original Message-----
I am trying to determine if there is a way to dynamically
update the data source underlying a pivot table. For
example, I have a data sheet that grows by one year each
month and this sheet populates a pivot table. Each time I
add a new row, I have to redefine the source data range
for the pivot table. Can this action be done
automatically? I have seen something like this to update
graphs using the series function... just not for pivot
tables.

Thanks in advance.
chaz
.
There is an easy solution to the problem. Set your range
Click to expand...
one row after the last line. For example if your
information finishes in row 10 set your range for the
pivot table to row 11. From now on just insert a row for
the amount of rows you need, that way the range will be
adjusted automatically. You will have a row that says
blanks, which you can deselect in the column name. You can
also set your range out by a few hundred or thousand rows
in order to compensate for future inputs.
I hope it helps.
 
Back
Top