View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Pivot Tables...argghh

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