DataChange Event

Microsoft Office Web Components Visual Basic

previous page next page

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.