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
0answers
11 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 ...
0
votes
0answers
10 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
22 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
17 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
27 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
17 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
40 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 ...
1
vote
0answers
85 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
0answers
26 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 ...
0
votes
0answers
66 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
34 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
1answer
46 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 ...
0
votes
0answers
47 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
49 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
66 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
0answers
56 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
121 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
43 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 ...
0
votes
0answers
3k 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
59 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
112 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. ...
0
votes
2answers
46 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
113 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
57 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
79 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?
0
votes
1answer
211 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
124 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
162 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
0answers
37 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 ...
1
vote
1answer
415 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
89 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
132 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
134 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
270 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
268 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 ...
2
votes
4answers
790 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
2answers
828 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
160 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 ...
0
votes
1answer
211 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
70 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 ...
2
votes
1answer
782 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 ...
1
vote
0answers
251 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
1answer
301 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 ...
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
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 ...
0
votes
1answer
2k views

How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View?

I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app ...
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 ...
1
vote
0answers
172 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 anyone ...