Application.SheetPivotTableBeforeCommitChanges Event (Excel)
Occurs before changes are committed against the OLAP data source for a PivotTable.
Version Information
추가된 버전: Excel 2010
Syntax
식 .SheetPivotTableBeforeCommitChanges(Sh, TargetPivotTable, ValueChangeStart, ValueChangeEnd, Cancel)
식 A variable that represents a Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Sh |
필수 |
Object |
The worksheet that contains the PivotTable. |
TargetPivotTable |
필수 |
The PivotTable that contains the changes to commit. |
|
ValueChangeStart |
필수 |
Long |
The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection. |
ValueChangeEnd |
필수 |
Long |
The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection. |
Cancel |
필수 |
Boolean |
False when the event occurs. If the event procedure sets this argument to True, the changes are not committed against the OLAP data source of the PivotTable. |
Return Value
Nothing
Remarks
The SheetPivotTableBeforeCommitChanges event occurs immediately before Excel executes a COMMIT TRANSACTION against the PivotTable's OLAP data source, and immediately after the user has chosen to save changes for the whole PivotTable.