invalid Default Values

Posted on 2009-12-18
Last Modified: 2012-05-08
I created a list by importing it from an excel spreadsheet.

It is a list of contacts. I would like to copy this list I imported to a Contact List but when I copy & paste the data I receive this error:

The rows you modified could not be saved to the server due to validation errors. This is usually caused by inavlid default values.

Can I turn off this data validation?

Is there a better say to get this info into a Contacts Sharepoint list?
Question by:sullisnyc44
    LVL 7

    Expert Comment

    It can be tricky to get this exactly right, one way that helps is to create some dummy entries in your contacts list, then export it to excel just to make sure that you have the columns in the right order etc. Another thing to check is that you are populating any required fields that are there, you can check which ones are required by going to the contacts list's settings and looking at the list of fields, you can also then set them to be optional. It can also depend on what exactly you have highlighted before you do your paste, sometimes it works if you have the first cell selected, other times you need to select the grey bar just to the left. Finally it can also help to take the 'Attachments' field out of the view you are pasting into, again go to the contacts list's setting and lookat the view you are using, untick any of the fields in it that you will not be pasting data into.

    LVL 7

    Expert Comment

    Oh, and you should be able to copy and paste direct from excel without using the intermediate custom list.

    LVL 12

    Accepted Solution

    create a contact list in moss using the contact list template.  make sure each column matches your exel spreadsheet.  Then create a datasheet view.

    ensure the items from left to right in datasheet view match your spreadsheet left to right, now  copy your speadsheet and then paste it in your your sharepoint list.  you should be good from there.

    This seems the quickest to me.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
    The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now