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

0
votes
1answer
17 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
15 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
14 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 ...
0
votes
0answers
47 views

Datasheet view bug in Explorer 11 and Edge

The organisation works with Internet Exploler 11 & Edge, and not everyone is able to open the list in datasheet view. One possible workaround is to enable the compatibility mode in explorer. But ...
1
vote
0answers
22 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
0answers
32 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
33 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
49 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
0answers
34 views

List DataSheet View: Notate Filtered Columns

When you filter a table in Excel using a column, it shows a filter icon. When working with a SharePoint (Services 3.0) list in Datasheet View and filtering on multiple columns, is there a way to get ...
0
votes
1answer
32 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
26 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
49 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 ...
1
vote
0answers
36 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
1answer
124 views

SharePoint 2013 DataSheet view

I've issue with SharePoint DataSheet view / quick edit. I've a library called Lib and in the library folder Folder1. In my AD I've 2 users - User1 and User2 User1 has contribute permission to the ...
0
votes
1answer
70 views

Stop editing this list throws javascript error

I've got the following issue in SP'13 that I'm struggle to fix. When I have a list with no items in it and I use quick edit mode, but didn't add any rows and then click Stop editing this list it is ...
0
votes
1answer
115 views

Is it possible to see the Data View with a picture library

I want to edit a Picture Library in SP 2010 it has a ton of meta data. Is it possible to edit it in a Data Sheet View or in excel or some other Data Sheet?
0
votes
0answers
28 views

Content Type Lookup Field is Read-Only

i cant set the content-type column in the datasheet view in MS access. sharepoint tells me the column is read-only but i cant find it in the column list because its a system standart and only looks ...
0
votes
1answer
15 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
2answers
198 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
35 views

Error in Datasheet view

I'm really blown away by this so I'm hoping someone can tell me I'm crazy. If I create a fresh list with 1 Optional field in it, then I remove the required 'Title' field and try to add an item in ...
0
votes
1answer
150 views

Why is the datasheet view not working for one user?

There is a document library in a SharePoint 2010 site. It has a datasheet view for mass editing, but one user is not able to get the view. He can navigate to it, but it just brings up a standard "list ...
0
votes
2answers
309 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 ...
0
votes
0answers
22 views

Lookup column displaying 0000000 in datasheet view

List A has a number column which has been looked up in List B. In datasheet view (only), the lookup column in List B displays 0's. For example, the value of List A is just 3, but in List B datasheet ...
3
votes
0answers
246 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 ...
0
votes
1answer
161 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
1answer
49 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
20 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
20 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
12 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: ...
0
votes
0answers
28 views

DataSheetView with Read-permission displays no items

When users with only Read-Permission access a DataSheet View in SP2013, the items in the list are not displayed. Do I need to create a new view for readonly users or is there a more elegant way to ...
1
vote
1answer
764 views

List cannot be displayed in Datasheet view

I can't open my list in Data sheet view. It throws me an error saying, can anyone help?
1
vote
0answers
126 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
278 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 ...
0
votes
1answer
93 views

Disable DataSheet view only on one specific ListView

I have setup a specific ListView with all the columns I need. I need to disable the Datasheet view on this ListView (called SubmittersList) then I need to have Datasheet view enabled on my other ...
1
vote
1answer
148 views

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

Is it possible to display the DataView Webpart in datasheet view?
0
votes
1answer
51 views

How does Datasheet View Calculate width?

I have created a custom masterpage, 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 datasheet window. If I ...
1
vote
2answers
11k 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
1answer
89 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 ...
0
votes
2answers
51 views

Datasheet style forms

Is there any way to do a datasheet type view for a form. I'd like to be able to allow people to enter multiple list items at once without giving them access to see the whole list.
1
vote
2answers
208 views

Sharepoint Standard View vs Datasheet View - Records showup

I have a weird problem. I have created 2 views, lets say ViewA and ViewB in a list with the same criteria. View A is a Standard View View B is a Datasheet View Strangely ViewA returns the records ...
0
votes
1answer
539 views

Disable automatic saving in Datasheet view

In the datasheet view of our list, if someone modifies a cell and then clicks into another one, changes are automatically saved. And you cannot "undo" them. Would there be a solution to deactivate ...
0
votes
0answers
31 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
163 views

Filter SharePoint 2010 datasheet view based on currentusergroups out of box

Please help if there is a solution out of box in SharePoint 2010, which helps filter datasheet view on currentusergroup. Through sharepoint designer, it is doable to change CAML <Query> ...
0
votes
1answer
338 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 ...
1
vote
2answers
852 views

Change Font Color in Datasheet View

I have a list that I have created in SharePoint 2010. Some of my customers prefer working in “Datasheet View” only. Can they change the font color to red in while in Datasheet View, or do they have ...
0
votes
2answers
108 views

Prevent datasheet mode of a standard view?

I have a standard view which has columns that should not be editable by everyone but need to be visible in the default view. There is a batch update view that is Datasheet, but I need to make sure ...
0
votes
2answers
606 views

Can not toggle back to Standard view of List

I am facing a very unique problem, for which i am not even able to understand, what to look for the internet. To give a brief : I created a list from some List Template with content. Than added a few ...
2
votes
1answer
223 views

How can I tell in a Sharepoint 2010 event receiver if the list item was added in datasheet view or not?

I'm a novice Sharepoint developer, so please forgive what is probably a very simple question. I have an event receiver on a custom list in Sharepoint 2010. I need to be able to display custom error ...
0
votes
1answer
479 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
1
vote
1answer
448 views

Can the Datasheet view open a URL field in a new window?

I have a list which contains a column containing a URL. When viewing this list using the Datashseet view, I want the URL to open up in a separate or targeted window, so as to not redirect away from ...