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

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

This site is currently not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .