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
2answers
26 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
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 ...
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 ...
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?
0
votes
1answer
661 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 ...
6
votes
1answer
667 views

How to maintain line breaks within a 2013 multi-line task field after datasheet edit

We use datasheets to edit multi-line task lists. Since being migrated to SharePoint 2013 the new datasheet view doesn't allow us to maintain line breaks after we stop editing the datasheet. Can ...
0
votes
1answer
735 views

can I use a wildcard in a datasheet view custom filter to NOT show titles that begin with certain words?

I have a calendar list view and want to be able to filter on the title to NOT show items that begin with the word Deleted. Can you use a wildcard at the end of Deleted to grab all titles that begin ...
0
votes
2answers
873 views

How to get rid of read-only column in datasheet view?

I'm trying to add lots of event to my calendar, so I'm using datasheet view of my calendar. But I found I can't copy-paste whole rows due to the recurrence column is read-only, and I can't hide it in ...
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
5answers
29k views

The list cannot be displayed in DataSheet view

I have two SharePoint Enterprise 2010 sites in two different farms. Both sites I am accessing with my local browser IE 10 (32-bit). List1 in Site1 can be opened in DataSheet view but List2 in Site2 ...
1
vote
2answers
2k views

Cut and Paste not working in Datasheet view Sharepoint 2013 O365

I have a question regarding an unusual error that I can't seem to resolve. I have a document library and am trying to cut and paste metadata from an excel 2013 spreadsheet into columns in a datasheet ...
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
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.
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
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 ...
1
vote
3answers
3k 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
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
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 ...
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() { ...
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 ...
4
votes
4answers
8k views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
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
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 ...
0
votes
2answers
856 views

How to make a list column and its items read only in datasheet view?

Is it possible to make a list items read only in datasheet view? Need the steps on making the datasheet view to be read only for a list. Thanks
3
votes
5answers
7k views

Cannot change value in a choice column for some documents

In a hosted WSS 3.0 environment I have a standard document library with some extra columns. For some reason I cannot change the value in a choice column (called: "Status"). The value always is reset ...
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?
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 ...
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 ...
2
votes
3answers
5k views

Unable open to List in Data Sheet List View

I am unable open my list in data sheet list view mode in Chrome browser but I am able to open in IE. Does any one know what kind of settings I need to change.
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 ...
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....
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
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), ...
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 ...
3
votes
2answers
4k views

SharePoint 2013: Adding old Access Datasheet View

We have migrated a lot of sites from SharePoint 2007 to SharePoint 2013. I observed a very unique behaviour, if my SharePoint 2007 list contained a Access Datasheet view, they remain the same and ...
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 ...
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 ...
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 ...