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
12 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 ...
4
votes
2answers
1k 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 ...
0
votes
0answers
42 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 ...
6
votes
1answer
358 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 ...
1
vote
1answer
643 views

SharePoint 2010 List Data Sheet Error

I have list with about 19.000 items. When I change the view to the DataSheetView, after a few minutes I'm gettin this error: " Cannot connect to the server at this time. You can continue working with ...
2
votes
2answers
708 views

Error when copying an empty choice field from Excel into a SharePoint 2013 Datasheet View

Once in a while, we need to upload a whole list of Project Ideas into our SharePoint 2013 Enterprise system. There is a datasheet view to copy all the fields from Excel into the list. Some of the ...
0
votes
1answer
1k views

Disable some of the columns in Datasheet view

Is there any way to disable just few of the columns in Datasheet view? I would like to show all the columns, but to allow the clients to edit only some of them, and in order to prevent any mistakes, ...
2
votes
3answers
3k views

Text in Datasheet view defaults to black highlighting (can datasheet view be configured at all?)

I'm not overly experienced with Sharepoint, but usually my Google-fu is pretty good...until now. Office 2007, SP 2007, Win7/Vista environment, I am a subsite administrator. When viewing a ...
1
vote
0answers
31 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 ...
3
votes
4answers
5k 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 ...
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
31 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
47 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
2answers
177 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
1answer
31 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 ...
3
votes
3answers
3k views

How to get Datasheet view working on Macintosh system?

How to get Datasheet view working on Macintosh system. Even many other features are not working on Safari browser. So is there any way to get it working?
0
votes
1answer
25 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. ...
10
votes
10answers
46k 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 ...
0
votes
1answer
48 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
1answer
115 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
0answers
26 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
0answers
34 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 ...
0
votes
1answer
67 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 ...
1
vote
0answers
113 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 ...
0
votes
1answer
105 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?
1
vote
2answers
829 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
290 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
1answer
1k views

Most “full control” users can't access datasheet view or export to Excel

All but the administrator users with "full control" and/or "contribute" permissons on a certain list do not recieve the datasheet view option, and when they try to export to Excel there is a ...
0
votes
0answers
26 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
0answers
34 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
143 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
0answers
21 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
232 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
154 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 ...
3
votes
4answers
4k 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 ...
0
votes
1answer
47 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
19 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
38 views

Datasheet view content types read only

We have a document library with 5 different content types. After bulk upload some documents an user can't change the content type in datasheet view. He gets the error message "column is read only". ...
1
vote
4answers
1k views

List Datasheet view blank

I have a List with some data in it. I can see the data while in standard view however when I switch to Datasheet view I only see a blank datasheet (no headings or data, just the MS Access icon and the ...
1
vote
1answer
700 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?
0
votes
1answer
84 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
0answers
268 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 ...
11
votes
2answers
6k 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 ...
2
votes
2answers
3k 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.
1
vote
1answer
2k 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?