Partager via


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.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace