Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to update Pivot Table
Hi
The name Total refers to a dynamic range, and I use it to make/update my Pivot Table. Each month Total expands with one column, and in order to update the Pivot Table I've to choose a) PivotTable, Refresh Data b) PivotTable, Wizard..., Finished - and then add the new column c) Then add the new column Is there a way to make a macro that allways reflect the dynamic range Total for all changes made, and that always sum up the values instead of count function? Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
record a macro to update pivot table | Excel Discussion (Misc queries) | |||
Pivot Table update | Excel Discussion (Misc queries) | |||
Give File Time to update Pivot Table when started bij Macro | Excel Discussion (Misc queries) |