Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel Pivot Table When New Data is Added using VBA
Hi there,
I have set up a pivot table and I use the following VBA to refresh. ActiveSheet.PivotTables(PivotTable1).RefreshTable My pivot table select the entire columns as its range and when data gets too large, it crashes the computer. Could you tell me how to specify the range so it would automatically pick all the data up to the last row? I have also specify last row with this VBA: LastSales = SalesWS.Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row Many thanks -- Picho |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Excel Pivot Table When New Data is Added using VBA
You could use a dynamic range as the source:
http://www.contextures.com/xlPivot01.html Picho wrote: Hi there, I have set up a pivot table and I use the following VBA to refresh. ActiveSheet.PivotTables(PivotTable1).RefreshTable My pivot table select the entire columns as its range and when data gets too large, it crashes the computer. Could you tell me how to specify the range so it would automatically pick all the data up to the last row? I have also specify last row with this VBA: LastSales = SalesWS.Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row Many thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Pivot Table with Data Added Monthly | Excel Discussion (Misc queries) | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
Can Excel Viewer be used to refresh data in a pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming |