Show AllOccurs when certain properties are changed or when certain methods are executed. See the PivotDataReasonEnum constant for more information about the properties and methods that can trigger this event.
| PivotDataReasonEnum can be one of these PivotDataReasonEnum constants. |
| plDataReasonAdhocFieldAdded |
| plDataReasonAdhocFieldDeleted |
| plDataReasonAdhocMemberChanged |
| plDataReasonAllIncludeExcludeChange |
| plDataReasonAllowDetailsChange |
| plDataReasonAllowMultiFilterChange |
| plDataReasonAlwaysIncludeInCubeChange |
| plDataReasonCommandTextChange |
| plDataReasonConnectionStringChange |
| plDataReasonDataMemberChange |
| plDataReasonDataSourceChange |
| plDataReasonDisplayCalculatedMembersChange |
| plDataReasonDisplayCellColorChange |
| plDataReasonDisplayEmptyMembersChange |
| plDataReasonExcludedMembersChange |
| plDataReasonExpressionChange |
| plDataReasonFieldNameChange |
| plDataReasonFieldSetDeleted |
| plDataReasonFieldSetNameChange |
| plDataReasonFilterContextChange |
| plDataReasonFilterCrossJoinsChange |
| plDataReasonFilterFunctionChange |
| plDataReasonFilterFunctionValueChange |
| plDataReasonFilterOnChange |
| plDataReasonFilterOnScopeChange |
| plDataReasonGroupEndChange |
| plDataReasonGroupIntervalChange |
| plDataReasonGroupOnChange |
| plDataReasonGroupStartChange |
| plDataReasonIncludedMembersChange |
| plDataReasonInsertFieldSet |
| plDataReasonInsertTotal |
| plDataReasonIsFilteredChange |
| plDataReasonIsIncludedChange |
| plDataReasonMemberPropertyDisplayInChange |
| plDataReasonMemberPropertyIsIncludedChange |
| plDataReasonOrderedMembersChange |
| plDataReasonRecordChanged |
| plDataReasonRefreshDataSource |
| plDataReasonRemoveFieldSet |
| plDataReasonRemoveTotal |
| plDataReasonSortDirectionChange |
| plDataReasonSortOnChange |
| plDataReasonSortOnScopeChange |
| plDataReasonSubtotalsChange |
| plDataReasonTotalAllMembersChange |
| plDataReasonTotalDeleted |
| plDataReasonTotalExpressionChange |
| plDataReasonTotalFunctionChange |
| plDataReasonTotalNameChange |
| plDataReasonTotalSolveOrderChange |
| plDataReasonUnknown |
| plDataReasonUser |
Private Sub Object_DataChange(ByVal Reason As PivotDataReasonEnum)
Object The name of the PivotTable object that you are trapping this event for.
Reason Use the value of the PivotDataReasonEnum constant to determine the reason that this event was triggered.
| PivotDataReasonEnum can be one of these PivotDataReasonEnum constants. |
| plDataReasonAdhocFieldAdded |
| plDataReasonAdhocFieldDeleted |
| plDataReasonAdhocMemberChanged |
| plDataReasonAllIncludeExcludeChange |
| plDataReasonAllowDetailsChange |
| plDataReasonAllowMultiFilterChange |
| plDataReasonAlwaysIncludeInCubeChange |
| plDataReasonCommandTextChange |
| plDataReasonConnectionStringChange |
| plDataReasonDataMemberChange |
| plDataReasonDataSourceChange |
| plDataReasonDisplayCalculatedMembersChange |
| plDataReasonDisplayCellColorChange |
| plDataReasonDisplayEmptyMembersChange |
| plDataReasonExcludedMembersChange |
| plDataReasonExpressionChange |
| plDataReasonFieldNameChange |
| plDataReasonFieldSetDeleted |
| plDataReasonFieldSetNameChange |
| plDataReasonFilterContextChange |
| plDataReasonFilterCrossJoinsChange |
| plDataReasonFilterFunctionChange |
| plDataReasonFilterFunctionValueChange |
| plDataReasonFilterOnChange |
| plDataReasonFilterOnScopeChange |
| plDataReasonGroupEndChange |
| plDataReasonGroupIntervalChange |
| plDataReasonGroupOnChange |
| plDataReasonGroupStartChange |
| plDataReasonIncludedMembersChange |
| plDataReasonInsertFieldSet |
| plDataReasonInsertTotal |
| plDataReasonIsFilteredChange |
| plDataReasonIsIncludedChange |
| plDataReasonMemberPropertyDisplayInChange |
| plDataReasonMemberPropertyIsIncludedChange |
| plDataReasonOrderedMembersChange |
| plDataReasonRecordChanged |
| plDataReasonRefreshDataSource |
| plDataReasonRemoveFieldSet |
| plDataReasonRemoveTotal |
| plDataReasonSortDirectionChange |
| plDataReasonSortOnChange |
| plDataReasonSortOnScopeChange |
| plDataReasonSubtotalsChange |
| plDataReasonTotalAllMembersChange |
| plDataReasonTotalDeleted |
| plDataReasonTotalExpressionChange |
| plDataReasonTotalFunctionChange |
| plDataReasonTotalNameChange |
| plDataReasonTotalSolverOrderChange |
| plDataReasonUnknown |
| plDataReasonUser |