Questions tagged [datasheet]

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.

Filter by
Sorted by
Tagged with
6
votes
1answer
9k views

Import/Copy/Paste Data from Excel into Existing SharePoint List

How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
2
votes
2answers
6k 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. Does ...
1
vote
3answers
3k views

Column Width in Quick Edit or Datasheet View

Is there a way to adjust the column widths or enable text wrapping in the Quick Edit or Datasheet view in SharePoint 2013? I have seen ways to set widths in the standard list view (using CSS), but ...
0
votes
2answers
5k views

Redirect to another page after submitting form [duplicate]

I have a sharepoint 2013 list. When the user clicks on edit this list to open it in a datasheet view...after making changes when clicked on stop ,the data should be saved and redirect to another page....
4
votes
3answers
10k views

SharePoint Online : Cannot view lists in DataSheet View

I want to view my list as datasheet. But I can't see it anywhere. Some sources that I found in Google said that I need to open in IE. But there's still no DataSheet option
1
vote
1answer
131 views

SharePoint Online CSR, make clickable link in Datasheet View

Want to create direct link to Document Set folders, so found and changed CSR that do this. Works well, but not in Datasheet View (it is not clickable in Datasheet View). Tried to change column types ...
0
votes
2answers
1k views

javascript event when a row is updated/changed in a Datasheet view?

Is there any way to catch update/changes in the Datasheet view of a list in JavaScript in SharePoint 2010? I see their are event receivers but nothing in Javascript.
10
votes
13answers
71k 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 ...
12
votes
2answers
8k 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
10k 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?
3
votes
1answer
3k 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 ...
6
votes
2answers
2k 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 ...
4
votes
4answers
7k views

Unable to save changes in Datasheet View

We have a custom list that we are trying to edit in Datasheet view and are getting the following error when the next row is clicked: Another user has changed the structure of this list. All your ...
3
votes
2answers
1k 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
8k 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
2answers
3k 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 ...
2
votes
2answers
1k 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 ...
1
vote
2answers
6k views

How can I restrict users from creating views in the Datasheet view in SP 2013?

I need to restrict users (with Contribute rights) ability to create Datasheet view. Also, how may I disable Quick Edit mode in all views?
1
vote
1answer
2k 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 ...
0
votes
1answer
663 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
439 views

Display Item Count in Quick Edit mode

Is there any way to display column count in Quick Edit mode? Datasheet view had this option to "Show Totals" but this seems to be missing with Quick Edit
0
votes
1answer
1k 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?