Home

Cannot disable [Export to Excel] feature

%3CLINGO-SUB%20id%3D%22lingo-sub-136803%22%20slang%3D%22en-US%22%3ECannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136803%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20donot%20want%20user%20that%20can%20use%20%5BExport%20to%20Excel%5D%20feature.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20997px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F25547i7B01CC392003CBDD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.png%22%20title%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20I%20should%20uncheck%20the%20following%20permission.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F25549i622A3AE73C725957%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.png%22%20title%3D%222.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20in%20my%20site%20although%20I%20have%20disabled%20the%20Client%20Integration%20features.%3C%2FP%3E%0A%3CP%3EThe%20user%20still%20can%20use%20%26nbsp%3B%5BExport%20to%20Excel%5D%20feature.%3C%2FP%3E%0A%3CP%3EI%20have%20check%20the%20user's%20permission%20there%20is%20no%20problem.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20someone%20tell%20me%20except%20permission%20problem%20what's%20the%20other%20reason%20can%20cause%20this%20situation.%3C%2FP%3E%0A%3CP%3E%26nbsp%3BAny%20help%20will%20be%20appreciate...%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%0A%3CP%3ETobey.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-136803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293924%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293924%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61094%22%20target%3D%22_blank%22%3E%40Tobey%20Davies%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EThank%20you%20for%20your%20response!%20It's%20SPO.%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CBR%20%2F%3EHi%20Tobey%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECreate%20a%20custom%20permission%20level%20with%20required%20list%20permissions.%20Under%20%22Site%20Permissions%22%20disable%20the%20following%20options%3A%3C%2FP%3E%3CP%3Ea)%26nbsp%3BUse%20Remote%20Interfaces%20-%20Use%20SOAP%2C%20Web%20DAV%2C%20the%20Client%20Object%20Model%20or%20SharePoint%20Designer%20interfaces%20to%20access%20the%20Web%20site.%3CBR%20%2F%3Eb)%26nbsp%3BUse%20Client%20Integration%20Features%20-%20Use%20features%20which%20launch%20client%20applications.%20Without%20this%20permission%2C%20users%20will%20have%20to%20work%20on%20documents%20locally%20and%20upload%20their%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssign%20this%20custom%20permission%20to%20the%20group%20which%20does%20not%20require%20%22Export%20to%20Excel%22%20option.%3C%2FP%3E%3CP%3EFor%20the%20list%20or%20library%20go%20to%20%26gt%3B%20Library%20Settings%20%26gt%3B%20Advanced%20Settings%20%26gt%3B%26nbsp%3BDisplay%20this%20list%20using%20the%20new%20or%20classic%20experience%3F%20-%20select%20Classic%20experience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20with%20custom%20permissions%2C%20the%20new%20experience%20has%20an%20option%20%22Export%20to%20Excel%22%20enabled.%20Hence%20the%20above%20step%20in%20Library%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20this%20also%20disables%2C%20%22Open%20with%20Explorer%22%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrust%20this%20helps%3C%2FP%3E%3CDIV%20class%3D%22ms-core-overlay%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202639%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202639%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20should%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202636%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202636%22%20slang%3D%22en-US%22%3E%3CP%3EShould%20this%20work%20for%20sharepoint%20online%20as%20well%3F%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202608%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202608%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20guys%20try%20this%20option%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.sharepointindepth.com%2Fhide-remove-the-export-to-excel-button%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.sharepointindepth.com%2Fhide-remove-the-export-to-excel-button%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202598%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202598%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Tobey%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20am%20facing%20the%20same%20problem.%20Were%20you%20able%20to%20find%20a%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-137561%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137561%22%20slang%3D%22en-US%22%3E%3CP%3EPermission%20can%20control%20Export%20to%20Excel%20feature.%3CBR%20%2F%3EI%20have%20found%20this%20is%20Limited%20Access's%20problem...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-136928%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136928%22%20slang%3D%22en-US%22%3EMmm...well%2C%20by%20using%20permissions%20you%20cannot%20enable%20%2F%20disable%20the%20Export%20to%20Excel%20option.%20The%20only%20option%20to%20disable%20the%20option%20is%20by%20means%20of%20some%20programming%20so%20you%20can%20program%20a%20piece%20of%20code%20that%20disable%20the%20option%20for%20this%20library%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-136820%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136820%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20response!%20It's%20SPO.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-136816%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20disable%20%5BExport%20to%20Excel%5D%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136816%22%20slang%3D%22en-US%22%3EIs%20this%20SPO%20or%20SP%20OnPrem%3F%3C%2FLINGO-BODY%3E
Highlighted
Tobey Davies
Contributor

Hi everyone

 

I donot want user that can use [Export to Excel] feature.

 1.png

 

I think I should uncheck the following permission.

 2.png

 

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.

9 Replies
Is this SPO or SP OnPrem?

Thank you for your response! It's SPO.

Mmm...well, by using permissions you cannot enable / disable the Export to Excel option. The only option to disable the option is by means of some programming so you can program a piece of code that disable the option for this library

Permission can control Export to Excel feature.
I have found this is Limited Access's problem...

Hello Tobey,

 

I am facing the same problem. Were you able to find a solution?

Should this work for sharepoint online as well?



 

Yes should work


@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

 
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies