Thanks Debra but this doesn't really address my concern of keeping adding
data to the source data simple. Lists and dynamic ranges seem like more work
than need be. :=

Is there no simple way of just adding rows and adjusting the source reference?

Kate


"Debra Dalgleish" wrote:

Make sure the pivot table source range includes the new rows. To do
this, you can right-click on a cell in the pivot table, and click on
PivotTable Wizard
Click the Back button, to got to Step 2.
Expand the range to include the new rows.

To include the new rows automatically, you can base the pivot table on a
dynamic range, as described he

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

Or, in Excel 2003, create a List (DataList), and base the pivot table
on that.
In Excel 2007, insert a Table, and base the pivot table on that.

KateW wrote:
I've been trying to add data (new rows) and then refresh my pivot to show the
changes but it isn't working and I suspect there's something basic here I'm
missing. I've looked at my Excel Step by Step book and all it says is add
the data and refresh which I've done. I created the pivot by clicking in the
data and then setting it up - do I need to link to the data in a different
way to get added rows? Office Online and Help don't seem to address this
basic issue.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html