Questions tagged [datasheet]

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.

Filter by
Sorted by
Tagged with
12
votes
2answers
8k 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 ...
10
votes
13answers
71k 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 ...
10
votes
1answer
327 views

Read Only in Datasheet view

I have a List that has a column that I changed from single line of text to multi-line text and now when in datasheet mode it tells me and my users the cell is read-only. it works fine in Standard View....
8
votes
3answers
852 views

Datasheet view added programatically missing from view selector

I am adding a new view to a list using CSOM (ViewTypeKind = Grid). The same code works perfectly for other types of views. For datasheet views, although they are added and they function properly, ...
7
votes
6answers
10k 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?
6
votes
1answer
9k views

Import/Copy/Paste Data from Excel into Existing SharePoint List

How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
6
votes
2answers
2k 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 ...
6
votes
1answer
675 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 ...
4
votes
1answer
2k views

External List in Datasheet View

How to I get an External List in Datasheet View? I have a List, whereby I have Looked up a Column from an External List. The column appears as readonly in Datasheet View, but behaves normally using ...
4
votes
3answers
10k views

SharePoint Online : Cannot view lists in DataSheet View

I want to view my list as datasheet. But I can't see it anywhere. Some sources that I found in Google said that I need to open in IE. But there's still no DataSheet option
4
votes
4answers
8k 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 ...
4
votes
4answers
7k 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 ...
3
votes
3answers
3k 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?
3
votes
5answers
7k views

Cannot change value in a choice column for some documents

In a hosted WSS 3.0 environment I have a standard document library with some extra columns. For some reason I cannot change the value in a choice column (called: "Status"). The value always is reset ...
3
votes
2answers
8k 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 ...
3
votes
1answer
3k views

How to add data sheet to a SharePoint web page?

I am using SharePoint 2007 + Windows Server 2008 with SharePoint 2007's publishing portal template. I want to add Excel style data sheet to a web page, could anyone show me how? More details, For ...
3
votes
2answers
1k views

Can I use JavaScript in 'Edit in DataSheet' mode?

I would like to use some JavaScript in 'Edit in DataSheet' mode to check a value and prompt a user to enter some text. Is this possible?
3
votes
1answer
47 views

problem with more than one datasheet views on SharePoint 2013 page

I have a problem with the datasheet views on SharePoint 2013. When I add more than one datasheet on a page I have some troubles with choice fields. When I try to select a value on the choice field ...
3
votes
1answer
2k views

SharePoint 2013 Online - Is it possible to freeze panes for a task list (header row)

We have a task list containing many items. The idea is to update the list in datasheet view. but Users complain that they can't freeze the top header row. I have suggested filtering the content ...
3
votes
2answers
4k 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 ...
3
votes
0answers
829 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
2answers
3k 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 ...
2
votes
3answers
5k 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
147 views

Datasheet view Headings modify

I am looking to modify the headings on a datasheet view of my list. I want to do any 1 of the 3 options below 1. Remove the headings column. I have tried adding the following code .ms-...
2
votes
1answer
802 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
1answer
4k views

Datasheet View works for a particular permission level only

Datasheet View works for particular permission level only on my site i.e. Contribute Permissions Level only. How can I make it work for all permission levels? PS: I have installed SP1 upgrade.
2
votes
3answers
6k 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 multiple-...
2
votes
2answers
3k 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 ...
2
votes
4answers
3k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
117 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 ...
2
votes
2answers
6k 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. Does ...
2
votes
2answers
480 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% ...
2
votes
2answers
2k views

How to create a “datasheet-like” list view to update a checkbox in multiple rows?

I am using draft item security on a forms library to only allow the creator of a form and a user with "edit items" permissions to view a form in the library. I would like to provide the user with "...
2
votes
1answer
58 views

Datasheet View to include overlay data

Is there a way to include the data from the calendar overlays in the datasheet view? I am trying to aggregate the data from the different calendars into a table or datasheet format.
2
votes
0answers
279 views

Attach file in Datasheet View

SharePoint 2007 allowed adding attachments to list items in Datasheet view. However, with SharePoint Online (Modern / Classic view) I do not get any options for attaching items in Datasheet view. Is ...
2
votes
1answer
313 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 ...
2
votes
0answers
112 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
335 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 ...
2
votes
2answers
1k views

How do I create custom control or action that works in a list's DataSheet view?

I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view. In datasheet view it is showing all the possible ...
1
vote
3answers
20k 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?
1
vote
2answers
3k views

creating datasheet view - but standard view is displayed by default

SPView AllItems = spList.Views["myview"] ; AllItems.Formats = "<Format Name=\"Modified\"><FormatDef Type=\"ColWidth\" Value=\"534\" /></Format>"; AllItems.Update(); Why isn't ...
1
vote
1answer
599 views

What are the new datasheet features in SharePoint 2010?

What are the new features with Datasheet functionality in SharePoint 2010 as compared to 2007? Areas of focus: Ability to control column width, Show/Hide, freeze header row? File operations from ...
1
vote
3answers
3k views

Column Width in Quick Edit or Datasheet View

Is there a way to adjust the column widths or enable text wrapping in the Quick Edit or Datasheet view in SharePoint 2013? I have seen ways to set widths in the standard list view (using CSS), but ...
1
vote
5answers
30k 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
2answers
3k 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
1answer
2k views

Solutions for Error: “The Datasheet view is attempting to retrieve data from a different domain”?

A couple users of our SP2007 site have received this error while accessing datasheet views. They are able to view/edit lists in 'standard view' without any issues and their PCs are configured with XP ...
1
vote
2answers
988 views

Site Upgraded from SharePoint 2007 to 2010 - Datasheet View error

When I try to put my "upgraded 2007 to 2010" list in "Datasheet View" I get an error: This list cannot be displayed in Datasheet View for one or more of the following reasons: A datasheet component ...
1
vote
1answer
27 views

SP2013 NOTES column won't accept PASTE

I have another one of my lists that I need help with. This list has a NOTES section that displays a LINK that says "View Entries...". While this may be an obvious statement, I cannot paste to this ...
1
vote
1answer
131 views

SharePoint Online CSR, make clickable link in Datasheet View

Want to create direct link to Document Set folders, so found and changed CSR that do this. Works well, but not in Datasheet View (it is not clickable in Datasheet View). Tried to change column types ...