The Stack Overflow podcast is back! Listen to an interview with our new CEO.
22

No No No No No No Yes, apparently: Create a view and select a Sort By column, then set that view as the default view The DataSheet view does not play ball. The problem is that the DataSheet view is a Microsoft Access generated data table, so there are none of the usual SharePoint hooks for interacting with it. Here are some more related questions: ...


10

From my experience, this is not possible through the SharePoint Dataview Sheet View. This is a new feature in 2010 and although super delicious and powerful, it still has a lot of issues that need to be resolved before it will be as powerful as it can be - in 2013, Microsoft has made improvements as per this article from MSDN To answer your question - in ...


10

Unfortunately, it's by design, you can't edit the multi-line text with Enhanced rich text (Rich text with pictures, tables, and hyperlinks) type in datasheet view To overcome this issue Specify the type of text to allow: Plain Text or Rich text (Bold, italics, text alignment, hyperlinks) instead of Enhanced rich text (Rich text with pictures, tables, and ...


7

There is no way to get the Datasheet view working in Safari. SharePoint Joel has a great matrix of which features work in which browser.


7

I stumbled across a way to fix this today. Under "Versioning Settings" there is a setting called "Require documents to be checked out before they can be edited" By default, in all my libraries, I have this set to "Yes" I discovered if I change that to "No" my datasheet views become read/write. Odd? Very. But it does seem to work. Incidentially, I ...


7

I changed the text type from 'Enhanced Rich Text' to 'Rich text' in the column setting(through List setting) from SharePoint and it worked for me.


6

This is one of the limitations of an external list; there is no way to get a datasheet view with the built in functionality of SharePoint. Other limitations are quite well ennumerated on this blog post. As you can see, there are quite a few of them and it is worth bearing these in mind when designing solutions with the Business Connectivity Services.


5

Datasheet view requires an ActiveX control not available for that platform. See Plan browser support (SharePoint Server 2010)


5

I had the same issue. There is another way to solve this problem with editing Multiple lines of text field in DataSheet(Access) view: Changing Versioning Settings for lists and libraries is useless. You should change field settings in SharePoint Designer. Open site- choose list, then right click on Multiple Line Field (with editing problem) and choose ...


5

If you're trying to get cell data from Excel (or any other table source) into a SharePoint list's Checkbox column in Datasheet view, the values in each source field must be delimited with the semicolon and hash characters (;#). Each cell's data must also have a leading and trailing semicolon/hash pair. This last bit is counter any other delimiting style I've ...


4

Intan, there is no 'DataSheet' button. What you are probably looking for is either Quick Edit or Export to Excel. You can find both of them on the list ribbon: Quick Edit will open a spreadsheet view of your list online. Export to Excel requires desktop Excel and will download the data to a local Excel file. The same functionality as with 'Quick Edit' can ...


4

The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. Let me break it down for you. :) Column Types Must be formatted as follows: -COLUMN- | -FORMAT / COMMENT- Single ...


3

Make sure you've configured the Datasheet section of Advanced Settings in List Settings. You should be able to edit the list in datasheet view, if the radio button is checked to "Yes" under "Allow items in this list to be edited using the datasheet and you have the correct permissions to modify the list.


3

I think you're missing the key point here. The datasheet view is not aware of you only having add or only update permissions. It enables you the ability to add as well as update and delete, erego you need the full contribute permissions in order to accomplish this task. I have used tools like jqGrid with the client side object model to implement a rich ...


3

You shouldn't expect SharePoint to work well opening any view with more that 2000/5000 items (depending on SQL server version). What may slow it further down is: Lookup columns (including User and Managed Metadata) Many columns of certain type causing SharePoint to use multiple rows in SQL for each item Many is defined as: 64 Single line of text 32 ...


3

IE makes use of a Web Datasheet Component (I believe via an ActiveX control), but Chrome uses "extensions" which are not supported at the moment. Refer to this article: http://veroniquepalmer.wordpress.com/2012/02/06/sharepoint-2010-compatibility-with-google-chrome/


3

In this kind of situations, I modify the column and make it allow fill in choices. Then I upload the data, which will not fail, and then change the allow fill in choices option back to No.


3

I've found that dates and username fields are especially susceptible to these errors. To paste a username in a field, that user has to 'exist' on that site. Just being a valid domain user is not sufficient. They must access the site at least once in order to get their userid associated with that site collection. If you enter them via the standard forms, ...


3

Follow these steps to accomplish your requirement: Create a column of type "Hyperlink or Picture" for your list (if it doesn't already exist) Add an item to the list with a valid URL in the new hyperlink column Open the list's "All Items" view in SharePoint Designer (SPD) Highlight the field containing the hyperlink and click "Code" (switches from Design to ...


3

Instaling of "2007 Office System Driver: Data Connectivity Components" resolved issue for me. Here is the link - http://www.microsoft.com/en-us/download/details.aspx?id=23734


3

Here is some CSS that should satisfy Option 1. .ms-viewheadertr *, .ms-viewheadertr { visibility: hidden; height: 0 !important; line-height: 0; padding-top: 0; padding-bottom: 0; border-top: 0 !important; border-bottom: 0 !important; } I chose to use visibility:hidden instead of display:none. By doing that there is still the ...


2

This looks to be a compatibility issue with .docx documents being used in older versions of SharePoint (ex. 2007). https://social.technet.microsoft.com/Forums/office/en-US/6799e3cc-99e9-4548-8484-90d51d77a505/metadata-fields-not-saving-from-edit-properties-form


2

Calculated columns don't work that way. Calculated columns set values based on information from other columns, not toggle visibility of form fields. The closest thing I can think of that you're wanting to do is a cascade dropdown, filtered options in a drop down list based on the selection of a previous column. The datasheet view cannot handle that to my ...


2

Use Internet Explorer only as the browser. Is not working for other browsers.


2

This is most likely due to the version difference (O2003 on MOSS2007). After googling around a bit I get the feeling the concensus is that O2003 lets you work with a list in datasheet view, but that fuunctionality is limited compared to when using O2007. Installing the Access 2007 Runtime (so you don't need the whole product) should fix the problem.


2

In addition to what Kambridge has added you also need to ensure you have correctly installed Office 2007 Data Connectivity Component in the client system. This is used by the Datasheet view.


2

You'll need to create a custom permission level that only gives users Edit Items permissions and apply that to a group of users in the list permissions.


2

The datasheet view is difficult to work with in that regard. You'll probably need to make your child list a multiple item form. This will allow for each line item in the child list to be edited on the fly, not as conveniently as a datasheet view but faster than editing each item individually through the UI.


2

We were able to resolve this for our users by installing Microsoft's Access Runtime. Link for SharePoint 2010. Link for SharePoint 2007. Hope this helps.


2

Yes it is, I have it in several locations. Create your desired datasheet view in the list, go to your web part page and add the list web part and change the view to use the datasheet view.


Only top voted, non community-wiki answers of a minimum length are eligible