View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tae-Suk Son Tae-Suk Son is offline
external usenet poster
 
Posts: 1
Default 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