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.

46 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
683 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 ...
3
votes
0answers
831 views

How to make cascade dropdown list in Datasheet View/Quick Edit mode?

I have a list with a need for cascade dropdown list. I've followed the instruction here and successfully create a cascade dropdown in a form. However, I'd like to ask for the possibility of creating ...
2
votes
1answer
61 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.
2
votes
0answers
290 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 ...
2
votes
0answers
112 views

How to find data source for a SharePoint 2007 Access Web Datasheet

I inherited a SharePoint 2007 site. There is a Access Web datasheet that is retrieving data from some kind of data source. The user has informed me that it is no longer updating. For further ...
2
votes
0answers
335 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
1
vote
0answers
41 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
0answers
106 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
0answers
113 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 ...
1
vote
0answers
129 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
256 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 ...
1
vote
0answers
56 views

Read Only fields in Datasheet view 2010 are Editable in 2013

We migrated a list from 2010 to 2013. The 2010 Version used an Access Web Datasheet View. 2013 uses the Quick Edit / Datasheet view. The fields that were Multiple Lines of text (Enhanced Rich) have ...
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
1k views

Feed a sharepoint list from a google sheet

I have a Google sheet that's being fed from a Google form. I am looking to import the new data into a list on Sharepoint as people continue to submit new items through the form. So far, I've been ...
1
vote
0answers
949 views

Disable datasheet/Quick Edit mode in SP 2013 on all views but one

Is there a proper way to do this in SP 2013? In 2010, you could just create your datasheet view and then click "disable editing in datasheet view" to prevent regular views from being converted. An ...
1
vote
1answer
343 views

Is it possible to display the DataView Webpart in datasheet view?

Is it possible to display the DataView Webpart in datasheet view?
1
vote
1answer
162 views

Can I lock the cells size in a datasheet view?

I'm working on Sharepoint2010. I have a datasheet which users can edit free. However I've noticed that everyone can change the size of the cells and even add other columns. How can I prevent any user ...
1
vote
0answers
106 views

Applying Datasheet view on a GridView Sharepoint

I was wondering if it is possible to apply Datasheet view onto a grid view found in an application page. The grid View was used such that the data is filtered out such that only data concerning the ...
1
vote
0answers
458 views

Form Library Updating fields in Datasheet view cause error

I have an InfoPath form that has been published and several fields have been promoted so that we can edit the fields in datasheet view. However, there are certain instances when we attempt to enter in ...
1
vote
0answers
202 views

Visible Column Descriptions in Datasheet View

Is there a way to change a Datasheet View in SharePoint 2010 so when a user hovers over the name of a column they'll get more descriptive text about the given column? Or something like a comment in a ...
0
votes
1answer
54 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#...
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 ...
0
votes
2answers
350 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
543 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
1answer
741 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 ...
0
votes
1answer
87 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
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
190 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
365 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 ...
0
votes
2answers
95 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
361 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
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
426 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 ...
0
votes
1answer
24 views

Can I create a group of dynamically added recipients, based on a datasheet?

I want my intranet users to send email to a distribution group. Not so strange so far, just a regular send list. But instead of a classic list with individually added recipients, they should be ...
0
votes
1answer
455 views

Datasheet View Cannot Access a Closed Stream

I am running into a problem where I have a Document Library with 2 Choices column. Each has it's own options. The problem is when I use the Datasheet View to edit these columns (or one of them), then ...
0
votes
2answers
960 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
26 views

No columns in datasheet view

I am unable to see any columns in the datasheet view of any list. Here's what I see: My coworker is able to see all columns as expected. Any ideas why this may be the case?
0
votes
1answer
24 views

How to show “edit in access” button

how to add the "Edit in Access" in the Ribbon? Currently, the Ribbon has the following: Export to Spreadsheet, View RRS Feed, Alert Me. thanks
0
votes
1answer
69 views

Combining Formulas

I need to combine the following formulas for SharePoint 2013. I've validated that each works separately, but when I try combining them I keep getting an error message. Any suggestions: =DATEDIF(...
0
votes
1answer
75 views

How does Datasheet View Calculate width?

I have SharePoint 2010, I have created a custom master page, and everything works except for the datasheet view. The problem I have is the scrollbar on the datasheet view goes passed the end of the ...
0
votes
0answers
38 views

Populate a column in SharePoint

I have 2 Different SharePoint installations. The new one is missing a column from when I used a tool to migrate. Now if I use the datasheet and export the missing column and its values to excel why ...
0
votes
1answer
742 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
1answer
667 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
0answers
1k views

Unable to Show Totals On Datasheet View

I have a SharePoint 2013 installation where a list is being displayed in Data Sheet view. When you select the option for the view to show totals for specific columns, the totals do not display until ...