A type of list view that organizes list columns into a spreadsheet format and can enable editing of multiple items at once without having to open each individual item.

learn more… | top users | synonyms

10
votes
1answer
4k views

Understanding Data Sheet view list better in SharePoint 2010

I would like to know more about the features of Data sheet type lists. Can I use conditional modification to the data sheet rows, for example changing the color if a column value equal 'X' ? Can I ...
7
votes
6answers
19k views

Why are fields in Datasheet View read only?

I have four metadata columns into which I cannot paste data for a bulk upload. A diaglog box: "The selected cells are read only" appears when I try to paste. The cells are defined as "multiple lines ...
1
vote
2answers
2k views

Error on adding people in SP 2013 datasheet view

When editing a Person or Group field in a datasheet view I always get the following error: The user does not exist or is not unique. If I enter the same name in the edit form it works fine. ...
7
votes
5answers
5k views

How do I hide the “Datasheet view” option in a list?

How do I hide the "Datasheet view" option (under "View Format") in a list's ribbon menu?
2
votes
1answer
2k views

How to add data sheet to a SharePoint web page?

I am using SharePoint 2007 + Windows Server 2008 with SharePoint 2007's publishing portal template. I want to add Excel style data sheet to a web page, could anyone show me how? More details, For ...
3
votes
1answer
483 views

Can I use JavaScript in 'Edit in DataSheet' mode?

I would like to use some JavaScript in 'Edit in DataSheet' mode to check a value and prompt a user to enter some text. Is this possible?
3
votes
2answers
4k views

Customising Data Sheet View

I'm using SharePoint 2007, with custom list. I'm using Content Editor web part in order to design my list. {In my list the row color determined through the item ststus. e.g: If the status equal to ...
2
votes
0answers
1k views

SharePoint List with multiple content types and the datasheet view

According to this thread. SharePoint 2010 does not "support" using the datasheet view with multiple content types configured anymore. But maybe somebody knows a workaround for my problem: I have a ...
2
votes
2answers
709 views

How do I create custom control or action that works in a list's DataSheet view?

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view. In datasheet view it is showing all the possible ...
2
votes
2answers
2k views

People or group column not working on datasheet view

I am facing an issue related to a custom group mapped to a list column. I have a custom list with a custom column "Responsible" of type "people or groups" with following settings, Allow multiple ...
0
votes
1answer
84 views

List Datasheet view stuck

I have one list where it opens like normal in the Standard View format and as expected I can switch to Datasheet View. The problem occurs when I want to switch back to Standard View. When in ...
0
votes
1answer
722 views

How to show the “description” of a Hyperlink column in the Datasheet View?

I have a list that uses a Hyperlink column (which contains the URL and description). When I use Datasheet View, I do not have the option to input the description field. Is there a way around this?
0
votes
1answer
1k views

Custom dropdown list field type in datasheet view (MOSS)

I would like to create a custom field type that renders a dropdown list, specifically to be used in the datasheet view. In the datasheet view it should render a dropdown list, (like a lookup field of ...