EnableDataValueEditing=true and copy & paste
 

Hi,

We have setup a Pivot Report where the data is editable and updates the
source tables based on user updates. The update works fine when the user
directly edits the value in the cell. We are using
EnableDataValueEditing=true setting to allow this feature. But, strangely, it
is not supporting copy & paste. Whenever a user tries to paste a value by
ctrl-v, Excel is displaying the following error message, "You cannot change,
move a part of, or insert cells in a PivotTable report. ....".

Any ideas on how to overcome this issue?

Thanks.

Tae-Suk