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