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

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

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 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.


6

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 ...


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 ...


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

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

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

I had the same issue. So I followed one of the previous posters advice and changed the Versioning Settings for libraries to "No". After the change, I still couldn't copy the data. I went back to the Multiple lines of text field that was causing the issue, and changed the "Specify the type of text to allow" to "Plain text". I was then able to do a bulk ...


2

If you have Multiple lines of text columns with Rich text or Enhanced rich text, you can't edit the columns with datasheet view with office 2010 (haven't tested other offices). Tbh I haven't looked much into the reasons, only learned to live with it :)


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.


2

If your input form is InfoPath you will also not be able to edit data with datasheet view. All those other setting about content approval and checkout won't matter.


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