I have an excel pivotgrid (connected to writeback enabled SSAS cube).
When i clear contents (select range & press DEL) of cells it fires PivotTableAfterValueChange event, but Value property of affected cells stil contained old value.
Moreover, CellChanged property stays xlCellNotChanged.
Is there any way to determine such clear event, to override existing behaviour?