Auto Update Range of a Pivot Table

I have created a simple data base and pivot table / report. I would like the pivot table to automatically update to a new range (if data has been added to the next available row of course) in addition to updating existing data. Can anyone help with this. I have used this to auto update the existing data when the sheet is activated.

Option Explicit

Private Sub Worksheet_Activate()

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh

End Sub

Works great. Thanks

Terri

Take a look at defining a range name that grows and contracts based on your
data.

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

TJDeborah wrote:
>
> I have created a simple data base and pivot table / report. I would
> like the pivot table to automatically update to a new range (if data
> has been added to the next available row of course) in addition to
> updating existing data. Can anyone help with this. I have used this
> to auto update the existing data when the sheet is activated.
>
> Option Explicit
>
> Private Sub Worksheet_Activate()
>
> ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
>
> End Sub
>
> Works great. Thanks
>
> Terri
>
> --
> TJDeborah
> ------------------------------------------------------------------------
> TJDeborah's Profile: http://www.excelforum.com/member.php...o&userid=33186
> View this thread: http://www.excelforum.com/showthread...hreadid=533987

--

Dave Peterson