This documentation is archived and is not being maintained.

PivotField.CalculatedItems Method 

Returns a CalculatedItems collection that represents all the calculated items in the specified PivotTable report. Read-only.

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

Dim returnValue As CalculatedItems
Dim pivotField1 As PivotField
returnValue = pivotField1.CalculatedItems()

CalculatedItems CalculatedItems();
public CalculatedItems CalculatedItems();
function CalculatedItems() : CalculatedItems;

For OLAP data sources, this method returns a zero-length collection.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms