Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table and Last Row
I am trying to refresh a Pivot table to the last row in a Macro. Any Ideas
Here is what I have so far Sub Refresh( Sheets("PivotCharts").Selec ActiveSheet.PivotTables("PivotTable11").RefreshTab l End Su Thanks in advance Aaron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table and Last Row
Are you trying to refresh the pivottable so it includes new data that
you've added to the source table? You can base the pivot table on a dynamic range, which will automatically expand to include new items. There are instructions he http://www.contextures.com/xlPivot01.html Then, when you refresh the pivottable, the new data will be included. Aaron wrote: I am trying to refresh a Pivot table to the last row in a Macro. Any Ideas? Here is what I have so far. Sub Refresh() Sheets("PivotCharts").Select ActiveSheet.PivotTables("PivotTable11").RefreshTab le End Sub -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |