Edit the range of a pivot table

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
 
G

Gary''s Student

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

Jacob Skaria

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
 
C

Christine

Thanks for the help. Dynamic ranges by converting to a table is FANTASTIC!
What a time saver.

Thanks!

Christine
 
J

Jacob Skaria

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

If this post helps click Yes
 

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

Adding data to a 2007 pivot table 2
Subtotal based on a range of data in Pivot Table 5
Increasing the Source Data range for an existing Pivot Table 2
Pivot table data source 1
Use Sum() with variable range 4
Average of Subtotals in Pivot Table 0
Pivot Table Wizard Fails to Recognize New Rows of a Named Range 3
Pivot Table - Old remaining values for rows 3

Top