Edit the range of a pivot table

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I have searched but can't seem to find this question begin asked before.

When I create a pivot table I have to identify the cell range to include in
that table. If the table keeps growing I would need to expand the range that
the pivot looks at. When I refresh the table it is only looking at the
original range of cells.

When the cells "out grow" the range, I have been deleting the table and
recreating a new one. I'm thinking that there is a way to modify the original
range.

If anyone can tell me how to do this it would be greatly appreciated!

Thanks,
Christine
 
Right-click on the table and pick the Wizard. Then touch the Back button.
Then expand the range.
 
Christine

Incase you are using excel 2007; convert the pivot table data range to a
table so that (new records added to the range will be automatically updated...

Take a look at the below video

If this post helps click Yes
 
Thanks for the help. Dynamic ranges by converting to a table is FANTASTIC!
What a time saver.

Thanks!

Christine
 
Pivot tables and charts too..That is one of the best things about tables in 07.

If this post helps click Yes
 
Back
Top