Patti,

I don't have 2007, but try inserting your new data within your old data
table instead of appending it on the end. Then just refresh your pivot
table. Since the data does not need to be sorted, you should be OK whether
you leave it alone or sort it after the insert.

HTH,
Bernie
MS Excel MVP


"Patti Newman" <Patti wrote in message
...
I have a very similar situation. Except I want to append the current data
with new data.

I'm using Excel 2007 and have a pivot table report that is cumulative.
Each
month I capture a new set of data for the table, paste it in the data tab,
but the pivot table only recognizes the original data set. In the previous
version of Excel, I could right click on the pivot table and rerun the
Pivot
Table Wizard, and highlight the entire data set to update it, but this
feature is not available to me.

I have been painfully recreating my pivot table each time I add new data
to
it.

Please help!
Patti