Forum Discussion
Hide "Export to excel" button
Hi ,
Are you talking about this feature ? Because i disable it and no luck. I try to the read permission as well and nothing......
SharePoint Server Enterprise Site features
Features such as Visio Services, Access Services, and Excel Services Application, included in the SharePoint Server Enterprise License. Florin AlbuTried a lot of things like permissions and list settings and still couldn't get the button away. If I can read the elements, they also go to Excel, even if RPC authorization in the permissions is off.
Hi, Tomislav Karafilov,
You can get rid of this Export to Excel button in ribbon, if you grant users custom permission level which doesn't have the below permissions:
1. Use Remote Interfaces - Use SOAP, Web DAV, the Client Object Model or SharePoint Designer interfaces to access the Web site.
2. Use Client Integration Features - Use features which launch client applications. Without this permission, users will have to work on documents locally and upload their changes.Hence, after creating this custom permission level, go to the list settings --> Permissions --> break inheritance, and then grant the users only this custom permissions level. Once done, these users won't see the option in the ribbon anymore.
Note: If users have Limited Access permission assigned to them in the list, they will still be able to see the Export to Excel option, as Limited Access permission enables this option...
However, please note that users can still connect to the list if they make this connection from Excel --> Import Data from SharePoint
