|Excel Developer Reference|
Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
With a CalculatedMember object you can check the validity of a calculated field or item in a PivotTable using the IsValid property.
|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.|
The following example notifies the user if the calculated member is valid or not. This example assumes a PivotTable exists on the active worksheet that contains either a valid or invalid calculated member.
|Visual Basic for Applications|