Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
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.