SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Your Answer


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.