Ltat42a

If you base your Pivot Table on a Dynamic Range Name, it will
automatically include any additions to the list when you refresh the
Pivot Table.

For really good instructions on how to create a Dynamic Range Name, see
Debra Dalgleish's website:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?

Regards,
Ron
(This may be a dbl-post...the first try bounced to an error screen)


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