PivotFormula Interface

Represents a formula used to calculate results in a PivotTable report.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("0002441E-0000-0000-C000-000000000046")> _
Public Interface PivotFormula
'Usage
Dim instance As PivotFormula
[InterfaceTypeAttribute()]
[GuidAttribute("0002441E-0000-0000-C000-000000000046")]
public interface PivotFormula

Remarks

Use PivotFormulas(index), where index is the formula number or string on the left side of the formula, to return the PivotFormula object.

This object and its associated properties and methods aren’t available for OLAP data sources because calculated fields and items aren’t supported.

See Also

Reference

PivotFormula Members

Microsoft.Office.Interop.Excel Namespace