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
16 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
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
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 ...
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
29 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
25 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
52 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 ...
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 ...
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 ...
0
votes
0answers
91 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 ...
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 ...
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
85 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
67 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
141 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 ...
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 ...
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
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. ...
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
126 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?
0
votes
1answer
269 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
131 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 ...
1
vote
1answer
502 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
93 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
179 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
144 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
311 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
293 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
886 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
987 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
181 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
239 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
73 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
842 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
264 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 ...