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