Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to switch off calculation on pivot tables.
As above.
There is a code: For i = 1 To iDataCols / 2 With ActiveSheet.PivotTables(sDatabase1Name).PivotField s(FieldNames(i)) .Orientation = xlDataField .Caption = "Sum of " & FieldNames(i) .Position = i .Function = xlSum End With Next i Every iteration needs more and more time, because pivot table is recalculated in each iteration. Is there any way to switch it off similar to Application.Calculation = xlCalculationmanual. Application.Calculation does not work on pivot tables. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to switch off calculation on pivot tables.
You could turn on manual update:
ActiveSheet.PivotTables(1).ManualUpdate = True witek wrote: As above. There is a code: For i = 1 To iDataCols / 2 With ActiveSheet.PivotTables(sDatabase1Name).PivotField s(FieldNames(i)) .Orientation = xlDataField .Caption = "Sum of " & FieldNames(i) .Position = i .Function = xlSum End With Next i Every iteration needs more and more time, because pivot table is recalculated in each iteration. Is there any way to switch it off similar to Application.Calculation = xlCalculationmanual. Application.Calculation does not work on pivot tables. Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to switch off calculation on pivot tables.
Perfect.
Thanks. Debra Dalgleish wrote: You could turn on manual update: ActiveSheet.PivotTables(1).ManualUpdate = True witek wrote: As above. There is a code: For i = 1 To iDataCols / 2 With ActiveSheet.PivotTables(sDatabase1Name).PivotField s(FieldNames(i)) .Orientation = xlDataField .Caption = "Sum of " & FieldNames(i) .Position = i .Function = xlSum End With Next i Every iteration needs more and more time, because pivot table is recalculated in each iteration. Is there any way to switch it off similar to Application.Calculation = xlCalculationmanual. Application.Calculation does not work on pivot tables. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default calculation for data fields in Pivot Tables? | Excel Discussion (Misc queries) | |||
How to set default calculation method in pivot tables? | Excel Discussion (Misc queries) | |||
How to Use pivot tables in a calculation | Setting up and Configuration of Excel | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Appending columns or calculation to pivot tables | Excel Discussion (Misc queries) |