I have setup a specific ListView with all the columns I need.

I need to disable the Datasheet view on this ListView (called SubmittersList) then I need to have Datasheet view enabled on my other ListView (called ApproversList). This is the reason I cant untick the Datasheet checkbox in the list settings as there are two views.

I am guessing there is a way I can do this through a content editor on AllItems.aspx with some javascript/jquery but I am struggling to start with the code.

Any suggestions would be must appreciated. Thanks.

1 Answer 1


First create a Datasheet view (ApproversList) and then disable Datasheet view in list settings. This way, the ApproversList will be still displayed as Datasheet but you will not be able to switch to DS view in other views.

Basically, the property Datasheet (Specify whether the datasheet can be used to bulk edit data on this list.) in list settings just enables/disables the button in ribbon.

  • Can you provide an example? Your words "..disable Datasheet view.." is too general.
    – ΩmegaMan
    Commented May 18, 2017 at 15:50
  • List settings -> Advanced -> Quick Edit = No
    – luccio
    Commented May 18, 2017 at 16:08
  • The OP said "...struggling to to start with the code". What value using either SOM or CSOM can one programmatically change a property on the SPList class to achieve the goal?
    – ΩmegaMan
    Commented May 18, 2017 at 16:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.