0

I can only paste one row at a time from an Excel sheet (.xls) into a datasheet view of a custom sharepoint list. The columns match exactly and all of the column types are set to "single line of text".

All rows paste successfully if done one at a time, the error only occurs if multiple are selected. This has worked previously but for some reason I get the below error message:

enter image description here

1

Make sure following:

  • excel table and your datasheet view line up exactly.
  • Don't have any "Created by," "Attachments" or "Last Modified" fields on there.
  • Make your selection within Excel, and then in datasheet, ONLY click into the top, leftmost field, (rather than making a paste selection)

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/bb38070e-9a0a-4dd7-9851-a5afb522f331/unable-to-paste-multi-rows-from-excel-to-datasheet-view-in-sharepoint-2010-list?forum=sharepointadminprevious

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.