Hi Willy

One problem with the approach you suggest, is the data will contain lots of
blanks.
If the OP wants to group dates, for example, into Weeks, Months or Quarters,
then they would not be able to.
Grouping dates will fail if any entry is blank or text.

Far better to go with Debra's dynamic range method.
Or if in XL2007 choose InsertTable then base the PT on the Table created.
In XL 2003, the equivalent would be DataListCreate
Before XL2003, neither List nor Table existed.

--
Regards
Roger Govier

"willy" wrote in message
...
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