Options:

1)If the data range is going to be expanding, you''ll need to make sure
the source range for the Pivot Table extends below the anticipated end
of the data. You may also want to set the Pivot Table to hide blanks.

2)Since the Pivot Table won't refresh automatically with data changes
(by design), you'll need to refresh it on demand.

Something you can work with?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=389628