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

1
vote
1answer
91 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
255 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 ...
7
votes
5answers
5k 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?
7
votes
5answers
17k 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
419 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
1answer
30 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
24 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
90 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
33 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
437 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
9 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
64 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
54 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
61 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
616 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
82 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
66 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
61 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
154 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
1k 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
85 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
1k 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
62 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
46 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
196 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
110 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
1k 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
0answers
49 views

datasheet view showing duplicates only one time

Is there a way to show sort/filter a column, e.g. Assigned to to only show one time? For example John Doe John Doe Mark Miller James Bond Now I want to filter the datasheet view to only show: ...
0
votes
2answers
777 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
0answers
14 views

One user/group updates via datasheet view,other users/groups single record with approval?

I have created a list on a SharePoint site. I need to configure the list permission so that one single user is allowed to use the datasheet view and can perform updates without approval all other ...
0
votes
1answer
895 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 ...
0
votes
0answers
141 views

Unable to filter a list in a Datasheet view using URL

After doing some reaserch about the issue (mostly by reading Q/A here and over the net). I'm still having hard time filtering my Inventory list using URL. My goal is to get just one row from the ...
0
votes
2answers
687 views

Should workflows run when creating a new item using the data sheet view?

I have workflow configured to start when an item is created. Using the datasheet view, when adding a row, the workflows are not fired. Is this by design?
1
vote
0answers
111 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 ...
2
votes
1answer
69 views

DataSheet View opens, but edits result in non-specific errors

SP 2010 Workstation = Win7 x64, Office 2010 x64, Office 2007 DataConn Components x32, MSIE 9 x32 I am trying to edit the metadata properties of several files in datasheet view. Datasheet view opens ...
0
votes
2answers
84 views

Datasheet view display wrong data

I have standart view filtered by choice field. Standart view shows me 748 items. Then I switch to Datasheet View (by button on ribbon) same view shows me 175 items. Also datasheets view shows some ...
0
votes
1answer
157 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 ...
1
vote
0answers
66 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 ...
2
votes
0answers
135 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
3answers
8k views

Editing in Datasheet View

I opened my list in datasheet view. But I wasn't able to edit in that view - things were read only. How do I enable edition in datasheet view?
3
votes
2answers
3k views

Customising Data Sheet View

I'm using SharePoint 2007, with custom list. I'm using Content Editor web part in order to design my list. {In my list the row color determined through the item ststus. e.g: If the status equal to ...
1
vote
1answer
77 views

How do I prevent “comments” cell within datasheet view from populating black after exiting cell?

A user of our SharePoint 2007 Server hosted database has been running into the issue shown within the title of this post. She is working remotely so, it is difficult for me to figure out what ...
1
vote
1answer
2k views

Unable to open task pane or fill down in datasheet view using IE 8

I've received a couple questions from people who all have issues using datasheet view when using IE 8 in SharePoint 2007. I've reproduced this in MOSS and WSS 3.0 with the same result. I use Office ...
1
vote
0answers
82 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
1answer
146 views

Custom alternative to Datasheet view of SharePoint

I have taxonomy fields as well as rich text boxes in my SharePoint 2010 list which needs to be edited in datasheet view so that bulk update is possible. Also I have Workflow goin on that list so ...
2
votes
2answers
325 views

How to make datasheet view 100% of browser height

Does anyone know the best way to remove scolling or even just expand the height of the datasheet view. I have two Sharepoint WSS 3.0 site collections, one displays the default datasheet view at 100% ...
0
votes
2answers
1k views

Datasheetview copy managedmetadata field

We have a list with 2 metadatafields, however in this list the user wants to use datasheetview to copy many rows, the problem is when you try top copy it says managed metadatafields are readonly, is ...
2
votes
2answers
828 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.
2
votes
1answer
2k 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 ...
10
votes
1answer
4k 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 ...