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.

ajames wrote:
>
> 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?
>
> --
> ajames
> ------------------------------------------------------------------------
> ajames's Profile: http://www.excelforum.com/member.php...o&userid=31502
> View this thread: http://www.excelforum.com/showthread...hreadid=514328

--

Dave Peterson