.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Issue with People and Groups type of column in datasheet view of shrepoint list.

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint

We have a list created in MOSS 2007 which has a column of type people and groups. When we open the list in datasheet view and try to add records for people and groups type of column the column shows only records from All People section of the site collection. I have verified this for another site collection within the same web application where I am able to see all the users though they are not in the All people section of site collection.
Could anyone please let me know if I am missing any setting or if there is any change required to see all the user names in the people and groups type of column in datasheet view.

Thanks ,

View Complete Post

More Related Resource Links

Datasheet view lookup column issue


When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.


Any ideas how to get this resolved?

WSS and MOSS Datasheet view people and groups bug or limitation

I need help trying to work around a limitation with the datasheet view with a list in sharepoint WSS and MOSS.  I need to figure out how to fix the people and group lookup fields so it will not corrupt my data. Currently  the data filters for this type of group does not work.  I have listed the steps below on how to recreate my issue:1. Create a sharepoint group called DELETEMETEST  > add a user to that group2. Create a new list3. Create a column in the list called DELETEMEPEOPLE > Select people only > Choose From DELETEMETEST Group4. Finish creating the list5. Create item in the list    * Notice that if you search for users in DELETEMEPEOPLE it will only show the users assigned to the group.6. Finish creating the record.Back at the listActions > Edit in DatasheetNotice that the DELETEMEPEOPLE now no longer has any filters, and you can add people outside of the DELETEMETEST Group.What are the possible solutions to working around this issue?1. Setting a bit flag on the SPField - Didn't see one that only worked for the datasheet.    2. You could make a custom field type of people and groups and that would make it read only in the datasheet, but isn't that a lot of work for something that is already created?Thanks for any advice....Ivan

Bulk editing issue - list cannot be displayed in Datasheet view



On a sharepoint page i click on 'Actions' tab then select 'Edit in Datasheet'  and i see the following error message


"The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. "


I am using XP professional, IE 6.02 to access the sharepoint site.


I was hoping that the hot fix KB938888 would fix that issue, but it did not. bulk editing is a nice feature that i would like to use but i have never been able to. The link to export data to Excel works fine.


if anyone has suggestions, thanks in advance


Custom list -- control issue with column type "Choice" and Infopath 2010

I finally got our project lead to abandon external SQL lists, so now I've created custom lists in SP 2010. I have some columns that are of "Choice" type/"Display as radio buttons" (customer requirement). When I start Infopath 2010 locally and create the data connections to the list(s), those choice fields display in I/P as dropdowns. If I change the control with a right-click to "Option Button", I only get one -- I need 2 (yes, no) or, in a few upcoming cases 3 or 4. BTW, same with changing the control to a check box -- only get 1. FWIW, I get the same results if I start Infopath directly from the list in SP Designer 2010. Any ideas?
Joel W. Johnson

Issue with List Definition of same base content type and deployed via same feature


I am trying to deploy two custom list definitions using only one single feature.  Below are the details of my issue.

  • Two custom list definitions
  • Each custom list definition has its own custom content type
  • Each custom content type inherits from the base content type Picture (Type = 109)
  • The custom list definitions are grouped together under one single feature
  • The custom content types are grouped together under a seperate single feature

When I deploy my solution in this configuration, the second list definition gets the first custom content type applied to it and the list schema from the first list definition is also applied to the second list definition.

What makes this more interesting, when I seperate both of the list definitions under two seperate features it all works fine.  Custom content types and list schemas get applied correctly.

Can anyone tell me why I can not deploy both list definitions under one single feature?

If you need me to post any of the origional code or XML to this post please let me know.



Persons and Groups column in datasheet

Hi - we have a problem where we have a column in a datasheet in sharepoint. The column is a person and group column and shows all people/groups etc as well as their presence using MS communicator. Works great on all PCs expect one which is using office 2010 32 bit. When you access the column in the datasheet via that single PC it only shows one option "NT authority\authenticated users" - instead of a list of the people and groups. Any ideas of how to fix this? Thanks

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns become read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug?

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns are read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug? Should I be able to edit them in 2010 and were they editable in 2007 version. Please help. thanks. I came across this other post which suggests that functionality is not available ? pls someone confirm. Mass-editing metadata when documents are uploaded (individually or in bulk) to MOSS 2010  

Cannot display list in Datasheet view sharepoint 2010

Hello, I encounter the following errror when I want to display a list in datasheet view: The error messaqe says: A datasheet component compatible wiht Microsoft Sharepoint Foundation is not installed Your web browser doesnt support active x controls a component is not properly configured for 30-bit or 64-bit support. Does anyone know how to solve this problem? I am running windows 7 X64 + Office 2010 x64 Internet explorer: 8.0 Thanks a lot, Jacques

How to link Title to it's associated page in list view without URL path column visible -bug?

I don't know if this is a bug or if I'm an idiot (or perhaps both, I'm open minded).   My site I'm developing is a site with publishing features activated where all my news stories are pages. What I want to have is a sortable list (the type hypothetically achieved using the XsltListView Web Part) the lists these pages with 3 columns visible: The Date created, the title (not the page name), and the author. The tricky part is that I would like the title, when clicked on, to take the person to the page. I'm actually almost there. I've created a new view with these specifications except for one issue. To make the title linked to the page, I have to have the column "URL Path" in my list view. When I remove this column, the titles instead all link to the root of the directory I'm in (ex: if I'm in Pages/Forms/My_List.aspx it will link to Pages/Forms/) Is this a bug, or is the URL Path required for the link to work? Is there a way to hide the column? Thanks.

Custom user selection in Person or Group type column as per other list.

I have two list in the Sahrepoint Foundation 2010 site. 1) Projects with Title and members(Person or Group - multiple selection) 2) Tasks (Team site default)  - added lookup column Projects form the first list (required) Now I want to assign task given users in the projects list. ex. I have users A,B,C,D,E and Two Project P1 and P2 I have defined that P1 project has users A,B,C so task is distributed/assigned between this members, not to D and E I need some validation or lookup which restrict selection or D and E.   Thank you.  

How to put Data in multi Taxonomy type fields using Datasheet view

Hi, We have a requirement where data has to be uploaded to a list having a Multi Taxonomy column.Is it possible to do so using datasheet view. Or please suggest if there is any other way. Thanks, Ash

Edit in Datasheet View on List is not working

I have a list with simple column types like single line of text, Number, Hyperlink,  Picture, choice. When i edit the list in datasheet-view, below error is getting displayed. An unexpected error has occured. Changes to your data cannot be saved. For this error, you can retry or discard your changes. This error is occuring on edit certain rows/columns only. The view is having a simple filter condition. Could anyone check and suggest a solution/workaround for this ? Thanks in advance.      

"The List Cannot be Displayed in Datasheet view....."

I created a standalone Win 2008 R2 x64 server,performed a Basic SharePoint Foundation (beta) install, installed Office 2010 on the same box, and am using IE 8 on that box to browse SharePoint sites. When I try to view a list in Datasheet view I get this error:The list cannot be displayed in DataSheet view for one or more of the following reasons:- A datasheet component compatible with Miicrosoft Sharepoint Foundation is not installed.- Your web browser does not suport ActiveX controls- A component is not propelry configured for 32- or 64-bit support.How can I troubleshoot this?TIA,barkingdog

How do I remove column headers in list view webpart?

I'd like to remove the column headers from a list view web part, as well as from a document library web part. How can I accomplish this in SharePoint 2010?

Is it possible to hide column header in list view webparts?


I can't seem to find a way to hide the column header of a list view web part.  Is it possible?  It appears that OOB the only list that doesn't show the column header in web parts is the Link List.


Display Version History in List View Column


I am working with a multitext line for comments and I have enabled versioning.  The version history shows in each item within the View Form.  I was wondering if I can have the comments field list in the List View as a column with all the version history.  Right now, it shows as a link "View Entries...".  I would like to be able to view all versioin history in the list view under the comments column.

Is is there a feasible solution?

Thanks in advance.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend