How do I hide the “Datasheet view” option in a list?

Question

How do I hide the "Datasheet view" option (under "View Format") in a list's ribbon menu?

Answer 1

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"
    Location="CommandUI.Ribbon"
    RegistrationType="List"
    RegistrationId="101">
    <CommandUIExtension>
      <CommandUIDefinitions>
        <CommandUIDefinition
          Location="Ribbon.List.ViewFormat.Datasheet" />
      </CommandUIDefinitions>
    </CommandUIExtension>
  </CustomAction>
</Elements>

Answer 2

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.

Answer 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;
});

Answer 4

Q: Have you tried simply unchecking the "Allow items in this document library to be edited using the datasheet?" to NO