Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy an entire row IF a statement is true | Excel Worksheet Functions | |||
If true, paste, then next cell | Excel Discussion (Misc queries) | |||
Copy if true | Excel Programming | |||
copy if true | Excel Programming | |||
Compare,copy and paste if true | Excel Programming |