Thread: Auto Update Range of a Pivot Table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TJDeborah[_2_] TJDeborah[_2_] is offline
external usenet poster
  
Posts: 1
Default 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


--
TJDeborah
------------------------------------------------------------------------
TJDeborah's Profile: http://www.excelforum.com/member.php...o&userid=33186
View this thread: http://www.excelforum.com/showthread...hreadid=533987

Reply With QuoteReply With Quote