I have a standard view which has columns that should not be editable by everyone but need to be visible in the default view. There is a batch update view that is Datasheet, but I need to make sure that's the only way they can go to a Datasheet view. Is this possible? I thought I could create a Datasheet view and then check the option to restrict Datasheet mode in order to accomplish this, but it seems to not let me even create a Datasheet view in that case. Is there another simple way of accomplishing this?

2 Answers 2


Oddly enough, my answer was in the question. You just need to create the datasheet view and THEN disable editing in datasheet view. The existing datasheet views are still visible but the standard views cannot be switched to their datasheet counterpart.


The list permissions should handle this for you. Make sure the permissions are set so that only the people who need to update the content have contribute access and everyone else has read only access. The read only folks could go into datasheet mode but they wouldn't be able to do anything.

  • I would need this restriction on contributors so that no contributor is able to switch to datasheet view of the all items view.
    – Dinerdo
    Commented Apr 30, 2014 at 18:23

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.