I keep getting the two error message when trying to copy/paste or use the autofill or fill down options on a list in datasheet view.

Datasheet bulk edit option is turned on and all columns which require data to be entered are on the datasheet view.

My clients need the ability to bulk-edit list entries, for example, when a supervisor changes. I tested the ability to edit in datasheet view on another list (my personal site) and works fine.

Here are error messages. Any help is GREATLY APPRECIATED.

Windows Internet Explorer (when I try to copy and paste) enter image description here

1 Answer 1


First error message is probably because you have missed a mandatory column in the view. So when you try to add items, the mandatory field will not get any value and you will not be able to add the item

Second could be due to a mandatory field missing, or could be due to one of the missing fields with both data validation and a default value (that fails the validation).

However I think it should be due to one or more mandatory fields missing from the view. Just check and add those to your view.

  • 1
    Nisary, thank you very much for your response. The resolution did have to do with mandatory fields. I studied a bit from home this weekend and found that I had to remove the "Require this column require information" option in List Settings on the customized list itself, but also had to remove the option from the associated content type (Item). That, my friend is the step I was missing.
    – RSpain
    May 2, 2016 at 14:32
  • That's great! So both the messages were due to a single error, right? May 2, 2016 at 14:35
  • YES!!!!!! Sorry for misspelling your name, Nisarg. :)
    – RSpain
    May 2, 2016 at 14:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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