Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system.
There is a datasheet view to copy all the fields from Excel into the list. Some of the choice fields are left blank in the Excel, and this causes the error " " is not a valid value" when I paste the items into the list. How do I get around this? Many thanks in advance.