People Picker Field on Datasheet View Empty

When working with a task list in datasheet view, the people picker drop-list should contain the users that are in the site’s user information list.   Occasionally, I have come across the scenario where this list is empty and only shows “(All)”, making the list useless.


  1. To resolve this issue, simply open the list in SharePoint Designer.  Select the list from the Lists and Libraries section. This will display the list settings page in SPD.
  2. Click Edit List Columns
  3. Click the person or group column to display the column editor.  Simply click OK.
  4. Click the Save icon in the title bar of SPD to save the list.
  5. Refresh the datasheet view of the list in SharePoint and now you should have people/groups to select from.

4 thoughts on “People Picker Field on Datasheet View Empty


    Thank you, thank you, & thank you. I’ve uninstalled office products, hot fixes, banged my head against the wall and was about to throw in the towel when I ran across your solution. I’ve spent way too much time on this – so I’m just thrilled thanks again.

  2. Casey Root

    This worked wonderfully on our end as well; only thing is it didn’t quite fully fix the problem. My user can now see more than All , however the list is limited to a certain group of people for some reason. Very odd.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s