PivotTable.AllocationValue Property
Gets or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property AllocationValue As XlAllocationValue
Get
Set
'Usage
Dim instance As PivotTable
Dim value As XlAllocationValue
value = instance.AllocationValue
instance.AllocationValue = value
XlAllocationValue AllocationValue { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlAllocationValue
An XlAllocationValue object.
Remarks
Read/write.
The AllocationValue property corresponds to the Value to Allocate setting in the What-If Analysis Settings dialog box. The default setting is xlAllocateValue, which corresponds to the The value entered divided by the number of allocations setting.