locked
Cannot paste excel data (multiple rows) into the datasheet view of a SharePoint 2007 list, even in a scaled down testing view. RRS feed

  • Question

  • Particulars:  The list contains several single line of text fields, a couple multiple lines of text,  a few choice columns, Person or group columns and a few date columns.  All of the multiple lines of text have been changed to be plain text per one of the blog posts on this site. Versioning is turned off. I do have management of content types turned on, but while testing this I have reverted every single field (on all content types) to optional.  Ideally we were using the ID field to increment an ID number when a new entry is created, however the view that I have been testing on does not contain this field.  The view I am using to test only contains a choice column, a date, and 3 text fields.   There is no columns showing “read only “ when selecting individually them in datasheet view. 
    So when I attempt to copy/paste a single row of data into the 5 fields, it works ok but still says columns that require data are not included in this view, but EVERY column in the list is set to optional... Is this because of the “out of the box” columns like submitted by & ID (even if they are not on this view)are still mandatory?
    I hope to get this working because clients need a way to keep an updated spreadsheet and be able to upload large amounts of data.  The sharepoint/excel sync  plugin has failed to work also.
    Any and all suggestions are welcome-- thanks  

    Thursday, June 21, 2012 9:31 PM

All replies

  • The required field here might be the column "content type". If you are using multiple content types in that list, Sharepoint may not be able to discern for which content type you are adding items through your Copy-Paste action in data sheet view.

    Monday, July 23, 2012 11:16 AM