Pivot Table Update?

[ajames]

I have an existing pivot table that works OK - but I want it to
recognise and automatically update when a new line of data is input -
how can I do this?

 

[Dave Peterson]

Use a dynamic range name--one that grows and contracts with your data.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

Then all you'll have to do is refresh the pivottable.