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?