You do not have permission to add rows to this list – Datasheet view

You do not have permission to add rows to this list.Changes to your data cannot be save. For this error, you can only discard your changes.

You do not have permission to add rows to this list
You do not have permission to add rows to this list

User has ‘Contribute’ access to the list and was able to add items to list using new item form. But whenever user tries to add items to list in data sheet view, this error comes up.


I verified for browser version (32 bit), Office installation version(32 bit), any issue with columns, rich text fields etc. Everything looks perfect, but user was still not able to add items through datasheet view.

After spending 30 mins online, I thought about similar issue I faced with Explorer view about which I blogged here. Thought it might be a similar one and BAM! That’s it. It is a permission issue. User have contribute access only to the list and no access(limited access) at site level.

Resolution: User needs to have atleast Read/View only access at site level for making using of datasheet view and explorer view options. Provided ‘View only’ access at site level for user and that fixed it. To edit in data sheet view, user needs access to some components which are at site level.

Hope this helps some one.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

User with Contribute access gets access denied

Only one user with contribute access gets access denied to SharePoint site collection. Every SharePoint admin might have faced this issue atleast once. In my case, user is added to a SharePoint group with Contribute access. Access shows up as Contribute when verified through site permissions – check permission option. Every other person in the […]

Read More