How do I add new data to a pivottable/chart?

I have a spreadsheet that I add new data to weekly. Is there a way to have
the pivottables/charts refresh to include this data without recreating them?
If I try to do extend the range of cells used to create them originally, I am
unable to group dates (which I need to do) on the chart because of blank
cells.

You can use a dynamic range as the pivot table source, and it will
automatically expand as rows or columns are added. There are
instructions here:

http://www.contextures.com/xlNames01.html

When you refresh the pivot table, all the new data will be included.


Brian Lee wrote:
> I have a spreadsheet that I add new data to weekly. Is there a way to have
> the pivottables/charts refresh to include this data without recreating them?
> If I try to do extend the range of cells used to create them originally, I am
> unable to group dates (which I need to do) on the chart because of blank
> cells.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html