Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view.
The sheet has 130 rows of data
I have done this before and made sure the columns match and all the data in the list matches.
I get the following
Error 3 cells could not be pasted. Some source rows which would have created new rows contained invalid values in required fields. These rows were skipped. Do you wish to continue with the operation and accept the changes. (Then it asks Yes No or Help.)
I click yes and from what it just said it should copy 127 of the rows but it only copies 14 of them instead.
I cannot find any similarity between the excluded rows and the accepted rows. Has anyone else had a similar issue before and if so what did you do?
I came to realize that the way two of the columns lined up it looked like both had data in the columns when really it was only in one of them. The second column was one of the required columns. I changed the column to be not required and it worked.
Thanks for everyone's input. I am marking tyshock's reply as the answer as his suggestion did help.