When you select the data, choose the whole column, by clicking on B and
extending the selection C D etc. This will set the PVT to look all the way to
the bottom all the time. With modern computers this is a mere trifle and
costs nothing in time, even with XL2007 going down 1048576 rows.
You can check this on old PVTs by clicking once on a cell in the PVT, and
then (in XL07) going to the menu PIVOT TOOL OPTIONS CHANGE DATA SOURCE and
seeing what the range is. To get rid of the row restriction use
Sheetname!$B:$F

Ciao Willy


"Dave Schreffler" wrote:

I create pivot tables in a time tracking worksheet I use each month. However,
when I go back to a saved worksheet and enter new data, I can't refresh the
pivot tables. Therefore, I have to re-build the pivot tables in each
employee's worksheet at the end of each month.

What am I doing wrong? :)
--
David Schreffler, EA