Forum Discussion

Tobey Davies's avatar
Tobey Davies
Brass Contributor
Dec 13, 2017

Cannot disable [Export to Excel] feature

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.

SharePoint Online
      • Sundar Arunachalam's avatar
        Sundar Arunachalam
        Copper Contributor
        Dec 03, 2018
        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

         

Resources