This documentation is archived and is not being maintained.

CalculatedMember Interface 

Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

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

Public Class alculatedMemberImplementation
	Implements CalculatedMember
End Class
Dim alculatedMemberImplementation1 As New alculatedMemberImplementation()

public interface CalculatedMember
public interface CalculatedMember
public interface CalculatedMember

Use the Add method or the Item property of the CalculatedMembers collection to return a CalculatedMember object.

With a CalculatedMember object you can check the validity of a calculated field or item in a PivotTable using the IsValid property.

Note The IsValid property will return True if the PivotTable is not currently connected to the data source. Use the MakeConnection method before testing the IsValid property.

Development Platforms

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

Target Platforms