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

10
votes
9answers
32k 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
17 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
3k 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 ...
1
vote
1answer
506 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
1answer
15 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
10 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
18 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
8 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
10 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 ...
0
votes
0answers
15 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". ...
0
votes
0answers
15 views

error;#1 Datasheet view

I've been asked to look at an issue in a share point 2010 list, multiple rows in a specific column contains simply following error;#1 rather than the expected data. What does error;#1 mean? I ...
0
votes
0answers
14 views

An unexpected error has ocurred. Changes to your data cannot be saved

When attempting to edit a column in a list I have, I instantly get following error message. Certain items update fine, but a very large amount fails instantly with this error. What could be causing ...
2
votes
4answers
894 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 ...
0
votes
0answers
30 views

2010 - List page editing with datasheet view

I have been asked to modify an existing list view using a datasheet web part to include static text to the right of the list (they want this text to constantly appear as users scroll down the ...
0
votes
0answers
27 views

Datasheet view changing size after zooming out and zooming back in

When i switch to datasheet view in a list the s4-widecontentarea will have a horizontal scroll bar. the right end of the datasheet view will be visible only if the horizontal scroll is moved to the ...
1
vote
1answer
53 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
0answers
24 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
0answers
58 views

Sharepoint 2013 missing a feature in edit list datasheet mode

I have a client who used the custom filter in 2010 quite heavily. On 2013, it is no longer available. Anyone know a way outside of a view. A view would work but the client needs to change it on the ...
2
votes
2answers
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 ...
0
votes
1answer
49 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
130 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 ...
10
votes
2answers
5k 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 ...
0
votes
0answers
27 views

In datasheet view I can't see the Modified column - SharePoint 2010

In Datasheet view I cannot see the default Modified column. when I switch to standard view I can see it fine, I have a custom date column that I can see fine in both views. Is this a SharePoint ...
2
votes
3answers
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 ...
0
votes
0answers
93 views

SharePoint 2013 upload speed to list is very slow

I am having speed issues when pasting data to a list in SharePoint 2013. I have IE 9 and Microsoft Office 2010. When copying data from Excel to SharePoint in Datasheet view (or quick edit view as it ...
0
votes
0answers
37 views

Datasheet view stops retrieving data

I have a list with 1065 elements. When it's opened in datasheet view, it loads first 100 and then it shows communicate "Retrieving data" on the bottom. This retrieving takes a really long time and in ...
2
votes
2answers
2k 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
1k 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?
0
votes
0answers
53 views

SharePoint 2010 Dataview webpart in Datasheet view

Is it possible to display a Dataview webpart in Datasheet view? To be more precise,I am using Dataview webpart to display a XML file data(using XML file connection in SPD).I would like to know if i ...
0
votes
0answers
62 views

SharePoint Designer - Datasheet view in webpart

I am using SharePoint Designer 2013 for building some customized webpages for SharePoint team site. I have created new blank .aspx page under sitepages folder. I inserted dataview by clicking ...
1
vote
1answer
86 views
0
votes
0answers
70 views

Stop Dataview from defaulting to edit mode when opened

When I open a Datasheet View it defaults to edit mode which I know it is supposed to do. But I would like if possible for the datasheet view to open as a read only list until Edit is clicked is there ...
0
votes
0answers
15 views

Edit item deletes previous metadata

We have a huge problem with some libraries in our SharePoint 2010. If we edit a document with the Ribbon Button "Edit item" all metadata deleted which have been saved in the previous versions. If we ...
0
votes
0answers
143 views

Force commit / 'Stop' editing Datasheet (Quick Edit) view Javascript

I have an 'Approve' button being rendered in a listview through JSLink. The users can click this in datasheet view to 'Approve' the item. The trouble is, and changes made before clicking approve are ...
0
votes
1answer
46 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
1answer
65 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
0answers
4k 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 ...
0
votes
0answers
119 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
3
votes
3answers
2k 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
2answers
47 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
127 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
0answers
61 views

Datasheet View hyper-link and column editing errors

I encountered an issue when using SharePoint 2010 having upgraded from office 2007 to 2013 (resolved here). Having installed the patch I've discovered that the datasheet view no longer allows me to do ...
0
votes
0answers
86 views

make content type column editable in datasheet view

I'm face an issue in a document library for a sharepoint 2010. I'm in datasheet view and i'd like to modify the column content type but it's in read only. Are there a way to do this?
1
vote
1answer
368 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 ...
7
votes
5answers
6k 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
274 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
28 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
132 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
186 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 ...
2
votes
1answer
844 views

Filtering datasheet view in Sharepoint 2010

I want to create a filter on Multiline Text Column inside a Datasheet View by means of out of the box features. Is it possible to provision such a feature so that when I click on the dropdown on such ...