Forum Discussion
Copy paste cells from excel pastes to single cell after update
2fabio I kind of figured it out even it makes no sense. First enter quickedit and mark the radial button to the left for the row you want to quickedit. Then mark the cell where you want to insert data and ctrl+v and it should paste the rows correctly. However, you can only paste 100 rows at a time (at the bottom you have the 0-100/101-200 etcetera). If you paste beyond the rows being shown you will get an error. And this is weird - you can only paste to rows that already exist. So when I wanted to paste 50 rows i had to mark a text cell and go "a enter a enter a enter...." 50 times in order to create 50 new rows before pasting the actual values I wanted. Also, Pasting 100 rows worked fine when it was 2-3 columns but when i tried to paste 8-9 columns at once I was unable to save the quickedit. Good luck!
Olof_W yes.. thanks.. it kind work... I was frustrated but I think the issue is that one column is a lookup on another list and the pasting process stops there!
with your explanation it makes sense.. you need to make room to be able to paste... probabbly!
also, I was able to press the button on the bottom left corner and go to classic sharepoint (just to paste) and it seems to work as before... but sometimes it fails on the lookup reference... saying that the pasted value is not correct.. and copying both (from excel and from the cell) to a notepad, both are identical...
again, thanks.. I will continue to try to paste...