You're probably right, actually, in your reading of the OP's post.
Dave
--
Brevity is the soul of wit.
"Ron Coderre" wrote:
I thought the problem was that refreshing the Pivot Table didn't
automatically include the new records. I didn't gather that the OP wanted
the Pivot Table to change immediately upon changes in the records. In
typical situations, you'd want the Pivot Table to update on-demand, instead
of re-arranging itself whenever the source data changed. That way once
you're done adding/deleting records, you could refresh the PT and see the
final product.
I could be wrong....(wouldn't be the first time...or the last)
***********
Regards,
Ron
XL2002, WinXP
"Dave F" wrote:
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