DataChange Event
PivotDataReasonEnum
| 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.
PivotDataReasonEnum
| 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 |
Applies to | PivotTable Object