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
2answers
33 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
2answers
6k 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
99 views

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

Is it possible to display the DataView Webpart in datasheet view?
1
vote
1answer
70 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 ...
1
vote
1answer
579 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 ...
1
vote
1answer
424 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
12 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
1answer
43 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
1answer
25 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
19 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
12 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
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
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 ...
0
votes
1answer
214 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
1answer
268 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 ...
0
votes
1answer
413 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 ...
4
votes
0answers
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 ...
3
votes
0answers
80 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 ...
2
votes
0answers
216 views

Data truncated when pasting worksheet into multiline field

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some ...
1
vote
0answers
148 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 ...
1
vote
0answers
76 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 ...
1
vote
0answers
273 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
0answers
210 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 ...
1
vote
0answers
84 views

How to find data source for a SharePoint 2007 Access Web Datasheet

I inherited a SharePoint 2007 site. There is a Access Web datasheet that is retrieving data from some kind of data source. The user has informed me that it is no longer updating. For further ...
1
vote
0answers
126 views

Visible Column Descriptions in Datasheet View

Is there a way to change a Datasheet View in SharePoint 2010 so when a user hovers over the name of a column they'll get more descriptive text about the given column? Or something like a comment in a ...
0
votes
0answers
10 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
0answers
16 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
0answers
14 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 ...
0
votes
0answers
18 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
19 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
17 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
17 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
32 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
35 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 ...
0
votes
0answers
33 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
79 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 ...
0
votes
0answers
28 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
114 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
42 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
54 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
77 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 ...
0
votes
0answers
95 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
168 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
0answers
125 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
0answers
29 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
0answers
454 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 ...