Tag Info

Hot answers tagged

16

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


8

As described in this article : Remove button from the Ribbon in SharePoint 2010, you can, with a feature, remove existing button. In your case, the feature.xml file should be : <?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <CustomAction Id="RemoveDataSheetButton" ...


5

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.


4

This issue will sometimes pop up if you commonly access your pages with two urls, i.e. http://mysite.company.com and http://machinename. Verify that the user is accessing the site using the URL specified as the primary address for that zone in Alternate Access Mappings. If you are using the http://machinename url convention, I would strongly recommend that ...


4

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


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

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


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 addition to Steve B's solution, another 2010-only way of doing this is to set the following property to true: SPList.DisableGridEditing Unfortunately there appears to be no way to do this in 2007.


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 could use javascript to do this. var menuItems = document.getElementsByTagName('ie:menuitem'); for (i=0; i<menuItems.length; i++) if (menuItems[i].text == 'Edit in Datasheet') menuItems[i].removeNode(); jQuery version: $("ie\\:menuitem[text='Edit in Datasheet']").each(function() { this.hidden = true; });


3

If your data is in a SharePoint List, you could just create a view on the List that is specifically of type DataSheet with the appropriate columns, go through the steps of adding a Web Part to your page (Site Actions-->Edit Page...) picking your SharePoint List which will use the default view initially, then choose Modify the Web Part from its dropdown menu ...


2

Just a lucky guess, but are you using Office 2010 x64, because: The Edit in Datasheet view functionality is not supported if you install 64-bit Office 2010. However, the functionality is available if you install 32-bit Office 2010. Source: 64-bit editions of Office 2010


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

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

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

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.


2

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


1

We have had success by installing this plug-in http://www.microsoft.com/en-us/download/details.aspx?id=4438 it turns out that the default font used in the datasheet view is no longer included in the Windows7 package.


1

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


1

I created a workflow that started on change to accomplish this. Navigate to your library. Open edit properties for one of your items and add a managed metadata value. Save. View the list/library in datasheet view to get the managed metadata "code" - will look something like 1;#ManagedMetadataValue. Copy this value EXACTLY how it appears. Create a workflow ...


1

Remove the metadata columns from the datasheet view. Since metadata columns are populated through Term Store or Enterprise Keywords , these values are only modified at the Term Store Administration level by Contributors or Group Managers. A list level user even though can update other list columns , but metadata columns are special columns whose data can be ...


1

I do not think it is possible to have the "spreadsheet" quality of a DataSheet View and use Group By, even using SharePoint Designer or jQuery. The closest functionality would be to use a regular view with grouping and allow inline editing (which is an option in the View Setting page). This will allow someone to edit one line at a time, but not perform group ...


1

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.


1

I would try IE's Developer tools (hit F12) to see which style settings are used by the views and compare the 2 pages. The dev tools will show you all styles used and whether they are for isntance inherited from a parent element and where they style rule was defined (css file, inline). The datasheet view itself is an ActiveX control by the way, so my guess ...


1

You should be able to do this using SharePoint Designer and the Data View Web Part. You might not even need jQuery. Check out Laura Rogers' blog - she has some very excellent step-by-step screencasts. http://sharepoint911.com/blogs/laura/Pages/Data%20View%20Web%20Part%20Screencasts.aspx


1

In your second screen-cast, the choices are shown as radio buttons. If the choices are look-up values, they should render as drop-down list. If I remember it correct, SharePoint does not provide option of radio buttons for look up column. Are you sure it is look-up column? Please confirm from the list settings page. By the way, It seems the selected values ...


1

It is just for the status column? Maybe I'm completely wrong, because your screencasts are from 2007, but I saw this behaviour once, after migration from MOSS 2007 to SP 2010 and it was problem with rights. Some documents was checked out or modified by "System account" (non existing users in the new farm or disabled in AD) and even logged with farm admin ...


1

There are known issues with IE9 with the ActiveX controls from SharePoint 2007 (and Project Server 2007). For some, setting the compatibility mode of the pages in the Master Page to quarks or IE 7 mode has helped. In the HEAD of your Master Page, try: < meta http-equiv="X-UA-Compatible" content="IE=5" / > or < meta http-equiv="X-UA-Compatible" ...


1

This might help: http://bmerri19.wordpress.com/2009/07/15/sharepoint-error-%E2%80%93-%E2%80%9Canother-user-has-changed-the-structure-of-this-list%E2%80%9D/ This is the content of the link: SharePoint error – “Another user has changed the structure of this list” July 15, 2009 Recently while working on a recent SharePoint project, we ran into a problem when ...



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