Adding cells to pivot table

  • Thread starter Thread starter Stephen Boulet
  • Start date Start date
S

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
 
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
 
It's almost easier to just create a new pivot table whenever you ad
data. It takes all of 20 seconds
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Help! 1
Turning Data into a Table 1
Export Pivot table 1
Pivot table report invalid 0
making an excel table visible for external data on pivot table 1
Excel 2007 graphs/charts automatically populate with new data 1
pivot tables in multiple workbooks using one datasheet? 3
pivot table loosing decimals (vba) 1

Back
Top