locked
sharepoint 2010: prevent users from editing a list in the datasheet view RRS feed

  • Question

  • Hi,

    I have a sharepoint 2010 list that I need to prevent users to edit from the datasheet view. This is because I have edited the add item form on sharepoint designer and included some custom code. Moreover, I need to allow the users to view the list in datasheet view to make use of the datasheet custom filter view feature which is not available in the standard view. So I need users to access the datasheet view of the list in read mode only but be able to edit the list in standard view only. Is this possible? How?

    Thanks,
    George

    Thursday, September 1, 2011 8:55 AM

Answers

  • Hi,

    Sharepoint 2010 does not provide permission functions on views. so there is no good way for this requirements.

    Regards,

    Seven

    • Marked as answer by Seven M Friday, September 9, 2011 8:33 AM
    Wednesday, September 7, 2011 9:00 AM

All replies

  • Hi.

    Maybe this helps...I found some users having the problem that the list WAS read only in datasheet view...this is a list of reasons why this could happen:

    Certain columns, such as Created By and Modified, are always read-only. Values for these columns are entered automatically.

    The changes you made to the selected row or column have been submitted to the server. If there is no conflict or error, you will be able to edit the row or column after the changes have been saved.

    There is an unresolved conflict or error in the selected row or column. Resolve the conflict or error before attempting to edit the selected row or column.

    The list is set up to require content approval, and you are viewing the list in the All Items view.

    In the My Submissions view of a list that requires content approval, the Approval Status and Comment column are read-only. Only a user with Manage Lists right can edit these two columns.

    Attachments are read-only in a list that requires content approval. You cannot view or edit attachments in any of the views.

    The document in the current row has been checked out by a user. You cannot edit the columns in the row until the user checks the document in.

    You do not have permission to edit the column or row. Contact the list author for more information.

    (from the help)

    You could also check: http://support.microsoft.com/kb/2274841

    Reverse engineer and you may have a solution? ;-)

     

    Regards

    hr class="sig">Thomas Balkeståhl - Technical Specialist - SharePoint
    • Edited by Brent Serbus Thursday, September 1, 2011 10:43 PM fix ux
    Thursday, September 1, 2011 9:12 AM
  •  So I need users to access the datasheet view of the list in read mode only but be able to edit the list in standard view only. Is this possible? -

    It's impossible. But :) you can try this trick - open list settings -> Versioning Settings -> Set "Require content approval for submitted items?" to "Yes". -> Click OK ). Open list datasheetview - it's readonly ;)



      


    Thursday, September 1, 2011 9:20 AM
  • I guess your suggestions make the datasheet view AND the standard view readonly not just the datasheet view so its impossible to achieve what I want. Thanks anyways!

    Thursday, September 1, 2011 10:29 AM
  • Hi,

    Sharepoint 2010 does not provide permission functions on views. so there is no good way for this requirements.

    Regards,

    Seven

    • Marked as answer by Seven M Friday, September 9, 2011 8:33 AM
    Wednesday, September 7, 2011 9:00 AM
  • How do i make a list which is not editable.  Users can add new records but cannot update those records.  This is needed for some type of expense approvals.. so that users don't edit the submitted expense.  

    The users input values into the Sharepoint through a InfoPath 2010 input form.

    I want to disable editing the list... but keep the add new record option open.

    Please help.

    Santosh Balan

    Tuesday, July 31, 2012 11:54 AM
  • Site Setting --> Site Permissions --> Click Permission Levels on the Ribbon

    Can create a new permission level and allow only the adding of new items, not editing or deleting.  This is achieved via the creation or editing of Permission Levels.

    Tuesday, January 28, 2014 1:51 AM
  • Go to the list settings, then click on advanced settings.  Then choose the option to disable edits in datasheet view.
    • Proposed as answer by toya0324 Tuesday, March 31, 2015 7:17 PM
    Tuesday, March 31, 2015 7:17 PM