Edit the range of a pivot table
 

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

Edit the range of a pivot table
 

Right-click on the table and pick the Wizard. Then touch the Back button.
Then expand the range.
--
Gary''s Student - gsnu200907

Edit the range of a pivot table
 

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
http://www.youtube.com/watch?v=h4T5NDmnVxo

If this post helps click Yes
---------------
Jacob Skaria


"Christine" wrote:

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

Edit the range of a pivot table
 

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

Thanks!

Christine

"Jacob Skaria" wrote:

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
http://www.youtube.com/watch?v=h4T5NDmnVxo

If this post helps click Yes
---------------
Jacob Skaria


"Christine" wrote:

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

Edit the range of a pivot table
 

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

If this post helps click Yes
---------------
Jacob Skaria


"Christine" wrote:

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

Thanks!

Christine

"Jacob Skaria" wrote:

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
http://www.youtube.com/watch?v=h4T5NDmnVxo

If this post helps click Yes
---------------
Jacob Skaria


"Christine" wrote:

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