return fields of a cell that it belongs to in pivot table

[phoeberunner]

Hi there,

I have a question on Excel VBA.

I have a pivot table, I set EnableDataValueEditing = true to allow user to modify data area in the pivot table.

For example, in the below pivot,


Sum of Sales Column Labels
Row Labels 2010 2011 2012 Grand Total
A 7700 17510 4723 29933
B 16073 13035 4274 33382
C 13109 21500 18362 52971
Grand Total 36882 52045 27359 116286

User want to change 7700 to 7000, how could I the changed value is the total sales of A in year 2010? Is there a pivot properties that can return the fields of a cell that it belongs to?


Thanks,
Sityee