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
0
votes
3answers
32 views

Export table to exisiting sharepoint list from excel

Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
0
votes
1answer
37 views

Create hyperlink to a filtered Datasheet view

Is it possible to create a direct link to a Datasheet/quick edit view which is already filtered. If I copy the filtered URL: http://example.com/sites/sitename/list/dataentryview.aspx#...
1
vote
1answer
26 views

Import Spreadsheet to Datasheet SharePoint with calculating columns

Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it'...
1
vote
0answers
32 views

New entry on top instead of bottom in SharePoint Online List Datasheet view

I have a list in SharePoint Online where the newest entry has to be on top of the datasheet view, I like to have the NEW empty row on TOP and not on bottom by Default as shown in the below screenshot ...
1
vote
1answer
27 views

Two Header Rows in Datasheet View

Is it possible to have two header rows? Example, one row is the title and the one below is the description. OR In the Column properties, can we add the Description as the 2nd row of the Datasheet ...
0
votes
1answer
15 views

List Datasheet upload & added column

This is hard to explain, but I'll do my best. I have a SP list where I update the data from an excel file and copy&paste it into the datasheet view of my SP list. I have a SP custom view of this ...
0
votes
0answers
11 views

Can a drop down list open automatically upon entering the field?

I have a list in a datasheet view with a drop down on the 3rd field. When I navigate into the 3rd field I want the list to open. The reason for this is beacuse the user is entering data via a ...
1
vote
1answer
27 views

SP2013 NOTES column won't accept PASTE

I have another one of my lists that I need help with. This list has a NOTES section that displays a LINK that says "View Entries...". While this may be an obvious statement, I cannot paste to this ...
1
vote
3answers
4k views

Change the background color for an entire column in a sharepoint online list

I've been looking for a solution to change the background color of specific columns in a SPO list. There seems to be a lot of information on conditional color coding but not the requirement that I am ...
1
vote
1answer
95 views

SharePoint Online, JSOM, 'ObjectSharingInformation is not defined'

How do You use ObjectSharingInformation in javscript? I get Uncaught ReferenceError: ObjectSharingInformation is not defined My function is something like function getSharingDetails() { ...
1
vote
1answer
123 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
1answer
127 views

Datasheet view edit list items not validating multiple users edition (SPOnline)

so we have a list that a lot of users edit at the same time in list view edit mode (datasheet view), if we were editing rows things at the same time we expected the red error telling us that one row ...
0
votes
2answers
280 views

List structure has changed error in Datasheet mode - SharePoint 2010

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 ...
0
votes
2answers
318 views

Create list datasheet view using the REST api

Provided following body content for a SharePoint REST api call: { '__metadata': { 'type': 'SP.View' }, 'Title': 'Awesome View', 'PersonalView': false } This creates a new view named Amesome ...
0
votes
1answer
463 views

Blank window when editing list item

I have a problem when I want to edit a list item. When click on it or "..." edit item I receive white window with "x" all items of the list. However when I want to add an item there is no issue; form ...
1
vote
0answers
103 views

is there any way i can get a js event or function when i edit cells in Datasheet/Quick edit view?

I need apply some client side changes when i click on cells for editing. i wanted to know if there is certain javascript event or functions which i can use to apply the changes through javascript/...
1
vote
1answer
92 views

Sharepoint 2010 Datasheet columns that require data are not included in this view

I have a problem in a lists datasheet view. It's a regular issue list with a custom content type added to it. In the content type, there are 9 fields that are set to require information. When I ...
0
votes
1answer
699 views

Why would DataSheet View work on 1 list but not another?

I created a list about a week ago (Custom List) and created a view from the DataSheet View template - and it works just fine. Today I created another list (Custom List) and then tried to create a ...
1
vote
0answers
109 views

Detect When new row is created in Quick edit view with the help of javascript/jQuery

I needed to apply certain validation on cells of Quick edit. I can apply once it is loaded thereafter I need any event so that I can detect when the user has created a new row and call my validation ...
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
1answer
146 views

Datasheet view Headings modify

I am looking to modify the headings on a datasheet view of my list. I want to do any 1 of the 3 options below 1. Remove the headings column. I have tried adding the following code .ms-...
0
votes
1answer
83 views

SP task list data push to SQL

What is my option so my sp task list still push the data to our sql database using the datasheet view? I was told that adding new item to the list triggers an event handler which uploads the data from ...
0
votes
1answer
428 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
2
votes
1answer
58 views

Datasheet View to include overlay data

Is there a way to include the data from the calendar overlays in the datasheet view? I am trying to aggregate the data from the different calendars into a table or datasheet format.
10
votes
1answer
310 views

Read Only in Datasheet view

I have a List that has a column that I changed from single line of text to multi-line text and now when in datasheet mode it tells me and my users the cell is read-only. it works fine in Standard View....
2
votes
0answers
273 views

Attach file in Datasheet View

SharePoint 2007 allowed adding attachments to list items in Datasheet view. However, with SharePoint Online (Modern / Classic view) I do not get any options for attaching items in Datasheet view. Is ...
1
vote
1answer
250 views

2013 - Populate column based on another value in datasheet view

I'm using SharePoint 2013. I'm trying to understand if is it possible to populate a column when another column is filled in datasheet view. I mean: I have a SharePoint list with "Start Date" and "...
0
votes
2answers
455 views

Create view, no “Datasheet View” option

In only one of my libraries (it's a picture library), there is no "Datasheet View" as an option when creating a new view? (Only standard view and calendar). It's Sharepoint 2013 I'm trying to follow ...
0
votes
1answer
47 views

Redirect from datasheet view in sharepoint 2013

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....
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....
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 ...
-1
votes
1answer
2k views

Adjust column width in Quick Edit or Datasheet View [duplicate]

I am trying to find a way adjust the column widths/wrap text in the Quick Edit/Datasheet view in SharePoint 2013. So far, I have only seen ways to adjust the widths in the standard view (using CSS), ...
3
votes
1answer
46 views

problem with more than one datasheet views on SharePoint 2013 page

I have a problem with the datasheet views on SharePoint 2013. When I add more than one datasheet on a page I have some troubles with choice fields. When I try to select a value on the choice field ...
1
vote
1answer
37 views

See More in DataSheet View?

This seems like a simple enough question although I can't seem to find the answer on Google or here thus far: Are you able to change the page when in Datasheet View - SharePoint 2010? I also ...
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
8
votes
3answers
838 views

Datasheet view added programatically missing from view selector

I am adding a new view to a list using CSOM (ViewTypeKind = Grid). The same code works perfectly for other types of views. For datasheet views, although they are added and they function properly, ...
0
votes
2answers
173 views

Can I revert File Names back to a previous file name?

I changed file names by mistake while in Datasheet View by dragging the corner of the top row down. The file names that changed need to be changed back to their previous and correct name.
0
votes
2answers
347 views

SharePoint - Make column read only in list based on condition

I have an Risk/Issue where the user selects from a drop down list if the item is an issue or a risk. Two fields severity and probability calculate together to give a score for Risks in my list. My ...
3
votes
1answer
2k views

SharePoint 2013 Online - Is it possible to freeze panes for a task list (header row)

We have a task list containing many items. The idea is to update the list in datasheet view. but Users complain that they can't freeze the top header row. I have suggested filtering the content ...
1
vote
2answers
1k views

Sharepoint-Online Caculated End Date shows as blank on Gantt View

I have noticed a number of issues with DataSheet/Gantt View when using calculated columns, i will list others at the bottom, however my main concern here is my gantt chart not showing an end date for ...
0
votes
2answers
91 views

Datasheet view export

I am using a datasheet view in sharepoint to manage an excel like sheet that multiple users can modify there data in. right now i export the list manually and upload it to the service provider. I am ...
0
votes
1answer
354 views

SharePoint 2013 Datasheet view is read only

I have created a DropOffLibrary, added a few documents. Then created a DataSheet View to allow quick edit of library properties. However, the view shows as read-only and does not allow inline editing. ...
0
votes
1answer
108 views

Error message in Datasheet View

I keep getting the two error message when trying to copy/paste or use the autofill or fill down options on a list in datasheet view. Datasheet bulk edit option is turned on and all columns which ...
1
vote
0answers
124 views

SP2013 Datasheet View Webpart

Have an SP2013 site that contains lists and pages with web parts that link to this list. One of the pages contains a Datasheet View what is used for a quick change in a particular field to kick off a ...
1
vote
1answer
106 views

Configure Hyperlink using calculated field to display in “Datasheet View”

We have a requirement to show hyperlink (URL underlying a text) in Datasheet view. Approach 1: We tried to create a hyperlink field and configured a WF to concatenate the URLs. It is working fine ...
1
vote
1answer
250 views

Sharepoint 2007 Datasheet View

I have read and read and read many sites on this and I have read a bunch from this site. I have a user that can't use datasheet view mode. The user was having an issue with not being able to export to ...
1
vote
0answers
72 views

Data view on lists not working to specific user

On our SharePoint 2010 site, one of the user is having full control but is unable to view datasheet view on any of the lists. When she clicks on datasheet view it is showing empty, and doesn't show ...
0
votes
1answer
331 views

Create a Link from a List to a Document in Library that I can edit

I have two pages. One page contains all of the documents for this site. The second page contains four different Datasheet Lists. I am trying to add a column that will link to the documents in the ...
0
votes
1answer
35 views

One user is unable to open in explorer/view in datasheet

One member of my team has lost the ability to open in explorer view and view in datasheet. Just randomly, and we cannot work out why. All settings are matching of his machine is matching with mine. ...
0
votes
1answer
411 views

Read Only field in View

We migrated a List with a field from 2010 where it was Read Only in Datasheet view. But in 2013 the Enhanced Rich Text field is now Editable. In 2013, Is there a way to make the Enhanced Text Field ...