Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?

share|improve this question

2 Answers 2

up vote 6 down vote accepted

According to @ToniFrankola http://serverfault.com/questions/73677/disable-export-to-spreadsheet-in-sharepoint-custom-list you need to have permission:

[x] Use Client Integration Features

In OOTB premission levels this permission is not set only for Restricted Read level.

So correct answer to your question is:

Minimum OOTB permission level for users to be able to export lists in Excel is View Only but minimum permission is Use Client Integration Features

You can always create your own custom permission level and select only Use Client Integration Features permission. (Note that two other permissions are automatically enabled: Use Remote Interfaces and Open.)

share|improve this answer

Try going to Site Permissions --> Permission Levels in the ribbon --> Select the permission level to view its properties and I think your looking for View Items in the List Permissions, not entirely sure but I usually play around with them till I get the desired result.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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