PivotTable.AllocationValue PivotTable.AllocationValue 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.

 property Microsoft::Office::Interop::Excel::XlAllocationValue AllocationValue { Microsoft::Office::Interop::Excel::XlAllocationValue get(); void set(Microsoft::Office::Interop::Excel::XlAllocationValue value); };
public Microsoft.Office.Interop.Excel.XlAllocationValue AllocationValue { get; set; }
Public Property AllocationValue As XlAllocationValue

Property Value



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.

Applies to