Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Update Range of a Pivot Table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto update my pivot table | Excel Discussion (Misc queries) | |||
Auto Update a Pivot Table | Excel Discussion (Misc queries) | |||
Auto update of Pivot Table | Excel Discussion (Misc queries) | |||
How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions |