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
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
13 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
4k 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
22 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
19 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 ...
0
votes
0answers
23 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 ...
2
votes
2answers
1k 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
849 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
37 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
32 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 ...
7
votes
6answers
24k 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 ...
1
vote
1answer
46 views
0
votes
0answers
36 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 ...
1
vote
2answers
613 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
12 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
85 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
36 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
50 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
1k 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
96 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
43 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
100 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
52 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
68 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
194 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
132 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
27 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
116 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
114 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
697 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 ...
0
votes
0answers
22 views

Embedding the Survey All responses view within a web part zone

SharePoint 2007 Standard Is it possible to embed just a view (All Responses) from a SharePoint Survey's AllItems.aspx into a web part zone? I'd like to embed this as a ways to allow a user to edit ...
0
votes
1answer
284 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
81 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
103 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 ...
3
votes
1answer
1k 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 ...
2
votes
1answer
114 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
180 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
188 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 ...
0
votes
2answers
532 views

SharePoint list not accepting copied excel data

Hello I am having an issue with a SharePoint list not accepting copied data from an excel sheet while in datasheet view. The sheet has 130 rows of data I have done this before and made sure the ...
1
vote
2answers
2k views

Error on adding people in SP 2013 datasheet view

When editing a Person or Group field in a datasheet view I always get the following error: The user does not exist or is not unique. If I enter the same name in the edit form it works fine. ...
1
vote
2answers
131 views

Pasting a rendered link to a rich-text column with the list in datasheet view

I'm trying to paste a rendered link, i.e., a link from within a Word or Excel file, into a rich-text column in SharePoint's datasheet view... Pasting from Excel, I get a working link, but it's the URL ...
1
vote
1answer
2k views

Summary Links Web part

Got about 60 links to add to a custom sharepoint, and I am going to use a summary link web part with an 'accordion style' like Stefan Bauer created. Adding a few are not a problem - but this is 60 ...
0
votes
1answer
134 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 ...
1
vote
0answers
64 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 ...
0
votes
0answers
329 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 ...
1
vote
0answers
203 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 ...
2
votes
2answers
2k views

People or group column not working on datasheet view

I am facing an issue related to a custom group mapped to a list column. I have a custom list with a custom column "Responsible" of type "people or groups" with following settings, Allow multiple ...
0
votes
2answers
1k views

Data Sheet view issues

I have a list with two views 1.data sheet view 2.standard view. users are able to edit datasheet view and standard view. The issue is when users want to edit Standard view in data sheet they are ...