Adding cells to pivot table

[Stephen Boulet]

Is it possible, once a pivot table is created, to add a few more rows of
source data to the original data range?

Stephen

 

[Debra Dalgleish]

You can use a dynamic data source for the pivot table. There are
instructions here:

http://www.contextures.com/xlPivot01.html

 

[Stephen Boulet]

Thanks for the hint ... that will work in a pinch; I just need to
remember to set up the table with a dynamic range in the first place.

Stephen

 

[wmjenner]

It's almost easier to just create a new pivot table whenever you ad
data. It takes all of 20 seconds

 

[Debra Dalgleish]

You can change the source for your existing pivot table:

Select a cell in the PivotTable
On the Pivot toolbar, choose PivotTable>Wizard
Click the Back button
In the Range box, type the name of your dynamic range
Click Finish