Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

In SharePoint 2007 I have a List containing two columns:

  • "Title" of type single line of text
  • "Email" of type Person or Group

Because I have to update a lot of records, I use export to Excel to update them. However, when I try to update the email of a record in Excel, I get the error message:

Data validation error; Datatype lookup; Restriction: Value must match one of the listed items;

Is there a way to bulk update these records?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

The "Email" column is in fact a lookup of Users; a choice of the users on your SharePoint site.

Each e-mail address corresponds to a user, so in changing the e-mail address you are attempting to change the user associated with that item. This means the e-mail address you are changing it to must match up to the e-mail address of an existing user.

If you're trying to update a user's e-mail address (rather than change the user associated with the item), then you'll have to do that directly in the user record.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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