We have a list with around 900 items, and recently the end-users decided to enable "Audience Targeting" on it. This added a new Audience Targeting column. The users now want to assign a default audience to many of the fields, and obviously they do not want to go through the entire collection and change them one by one. We tried to edit this column using a datasheet view without success (we got a nice "The selected cells are read-only" error -- I assume it is because the field type..)
Is it any way I could "batch update" that column in some of the items using a PowerShell script? Any other way to accomplish this?
Many thanks in advance,