Dec 13 2017 04:09 AM
Hi everyone
I donot want user that can use [Export to Excel] feature.
I think I should uncheck the following permission.
But in my site although I have disabled the Client Integration features.
The user still can use [Export to Excel] feature.
I have check the user's permission there is no problem.
Can someone tell me except permission problem what's the other reason can cause this situation.
Any help will be appreciate...
Thanks!
Tobey.
Dec 13 2017 05:38 AM
Thank you for your response! It's SPO.
Dec 13 2017 10:30 AM
Dec 14 2017 05:45 PM
Permission can control Export to Excel feature.
I have found this is Limited Access's problem...
Jun 09 2018 12:26 PM
Hello Tobey,
I am facing the same problem. Were you able to find a solution?
Jun 09 2018 02:50 PM
Did you guys try this option?
http://www.sharepointindepth.com/hide-remove-the-export-to-excel-button/
Jun 10 2018 01:20 AM
Should this work for sharepoint online as well?
Dec 02 2018 04:36 PM
@Tobey Davies wrote:Thank you for your response! It's SPO.
Hi Tobey,
Create a custom permission level with required list permissions. Under "Site Permissions" disable the following options:
a) Use Remote Interfaces - Use SOAP, Web DAV, the Client Object Model or SharePoint Designer interfaces to access the Web site.
b) 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.
Assign this custom permission to the group which does not require "Export to Excel" option.
For the list or library go to > Library Settings > Advanced Settings > Display this list using the new or classic experience? - select Classic experience.
Even with custom permissions, the new experience has an option "Export to Excel" enabled. Hence the above step in Library settings.
By the way, this also disables, "Open with Explorer" option.
Trust this helps
Nov 18 2020 01:23 PM
@Sundar Arunachalam I tried this today (SP Online), and when I tested, I couldn't get to the list at all. Site-yes, list-no. I tried again, re-enabling "Use Remote Interfaces," but I still couldn't access the list. I see that I can't select only "Use Client Integration Features" because when I deselect "Use Remote Interfaces," "Use Client Integration Features" automatically deselects as well.
I realize this conversation took place a couple of years ago, but if you have any additional suggestions, I'd really appreciate it.
Nov 18 2020 01:40 PM
@Sundar Arunachalam I think I figured this out!
Result:
If I find out anything else of interest, or if I find that this is somehow not working, I'll reply again. Thanks for your help!