You also need to add code to your pivot table that tells it to refresh when
the dynamic named range has been expanded, don't you?
--
Brevity is the soul of wit.


"Ron Coderre" wrote:

What you need to do is base the Pivot Table ons a Dynamic Named Range that
grows and shrinks when you data does.

See Debra Dalgleish's website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"frustratedwthis" wrote:

I have a pivot table that summarizes the information by Vendor from a PO Log
(on a different sheet). It works great UNLESS a row is added on the PR Log.
If I add a row (within the pivot table data area) it does not show on the
pivot table...
Is there a way around this?? or should I just not add rows?
Thanks in advance