Hi
On the Pivot table, click on the pivot table wizard, slect back, m and
increase the range of the rows. It should just bne the number you need to
change. I would suggest, putting in a row range much bigger than needed, so
it will take into account all future extracts
Thanks
Matt

Jaybatz wrote:
I make weekly budget reports, and I use a PivotTable to get a basic overview.
Now the problem is that as I extract data weekly, it changes and rows are
added to the original data each time. The PivotTable does not recognize this
and only checks the original field range. How do I change the range, without
having to create a new PivotTable every week?

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200808/1