Hide "Export to excel" button

%3CLINGO-SUB%20id%3D%22lingo-sub-336166%22%20slang%3D%22en-US%22%3EHide%20%22Export%20to%20excel%22%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-336166%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20i%20can%20hide%2Fdisable%20%22Export%20to%20excel%22%20function%20in%20the%20modern%20experience%20%3F%20The%20reason%20behind%20this%20is%20because%20my%20users%20are%20exporting%20the%20data%20for%20no%20reason%2C%20just%20because%20they%20are%20more%20familiar%20with%20excel%2C%20instead%20of%20working%20directly%20on%20the%20list.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-336166%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-339214%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20%22Export%20to%20excel%22%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339214%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F149327%22%20target%3D%22_blank%22%3E%40Florin%20Albu%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EThere%20are%20no%20options%20to%20manipulate%20the%20ribbon%20or%20a%20single%20button%20on%20it%2C%20neither%20in%20Modern%20Layout%20nor%20in%20classic%20Layout%2C%20if%20you%20don't%20want%20to%20manipulate%20the%20masterpage.aspx%20and%20this%20is%20very%20dangerous.%20I%20am%20sorry.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBUT%3A%20You%20can%20click%20to%20install%20and%20create%20a%20new%20default%20sharepoint%20form%20for%20your%20list%20with%20POWERAPPS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20you%20clicked%20it%2C%20PowerApps%20(available%20on%20Office%20365%20E1%20and%20higher%20i%20guess)%20opens%20in%20another%20tab%20to%20create%20automatically%20a%20new%20form%20with%20the%20fields%20you%20have%20already%20in%20your%20list!%20If%20you%20click%20back%20to%20the%20previous%20tab%2C%20your%20list%20has%20got%203%20or%204%20options%20in%20that%20ribbon%20and%20thus%20you%20can%20only%20work%20within%20powerapps%20form%2C%20without%20the%20modern%20ribbon.%20But%20it%20is%20then%20only%20a%20new%20view%20to%20change%20for%20your%20list%20view.%20Pls.%20check%20and%20see%20the%20different%20views%20then%20in%20the%20top%20right%20of%20that%20list%20view%20and%20change%20back%20to%20%22all%20items%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20find%20your%20form%20settings%20in%20clicking%20on%20the%20gear%20-%26gt%3B%20LIst%20settings%20-%26gt%3B%20Form%20Settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20you%20can%20also%20change%20back%20to%20the%20default%20aspx%20form%20if%20you%20dont%20like%20your%20powerapps%20form.%20But%20I%20highly%20recommend%20this%20in%20every%20case%20because%20then%20you%20can%20decide%2C%20whitch%20action%20is%20performed%20on%20which%20button%20you%20created%20it%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThus%20no%20excel%20export%20button%2C%20if%20you%20don%C2%B4t%20want%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338969%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20%22Export%20to%20excel%22%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338969%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3EAre%20you%20talking%20about%20this%20feature%20%3F%20Because%20i%20disable%20it%20and%20no%20luck.%20I%20try%20to%20the%20read%20permission%20as%20well%20and%20nothing......%3C%2FP%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CTABLE%20border%3D%220%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CH3%20id%3D%22toc-hId-1479647258%22%20id%3D%22toc-hId-1512718026%22%20id%3D%22toc-hId-1512718026%22%3ESharePoint%20Server%20Enterprise%20Site%20features%3C%2FH3%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFeatures%20such%20as%20Visio%20Services%2C%20Access%20Services%2C%20and%20Excel%20Services%20Application%2C%20included%20in%20the%20SharePoint%20Server%20Enterprise%20License.%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338297%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20%22Export%20to%20excel%22%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338297%22%20slang%3D%22en-US%22%3EHi%2C%20you%20could%20deactivate%20the%20Excel%20Services%20in%20the%20one%20shared%20site.%20Go%20to%20your%20site%20settings%2C%20then%20click%20to%20site%20features.%20There%20you%20can%20disable%20it.%20Unfortunately%20the%20button%20in%20the%20ribbon%20can%E2%80%99t%20be%20hidden.%20Or%20you%20check%20your%20group%20permissions.%20There%20is%20a%20permission%20level%20called%20%E2%80%9Eread%20only%E2%80%9C.%20Greets%2C%20Eva%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1074089%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20%22Export%20to%20excel%22%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1074089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F149327%22%20target%3D%22_blank%22%3E%40Florin%20Albu%3C%2FA%3E%3CSPAN%3ETried%20a%20lot%20of%20things%20like%20permissions%20and%20list%20settings%20and%20still%20couldn't%20get%20the%20button%20away.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20I%20can%20read%20the%20elements%2C%20they%20also%20go%20to%20Excel%2C%20even%20if%20RPC%20authorization%20in%20the%20permissions%20is%20off.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys,

 

Is there any way i can hide/disable "Export to excel" function in the modern experience ? The reason behind this is because my users are exporting the data for no reason, just because they are more familiar with excel, instead of working directly on the list.

Thanks

4 Replies
Highlighted
Hi, you could deactivate the Excel Services in the one shared site. Go to your site settings, then click to site features. There you can disable it. Unfortunately the button in the ribbon can’t be hidden. Or you check your group permissions. There is a permission level called „read only“. Greets, Eva
Highlighted

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.

 

Highlighted

Hi @Florin Albu,

There are no options to manipulate the ribbon or a single button on it, neither in Modern Layout nor in classic Layout, if you don't want to manipulate the masterpage.aspx and this is very dangerous. I am sorry.

 

BUT: You can click to install and create a new default sharepoint form for your list with POWERAPPS.

 

After you clicked it, PowerApps (available on Office 365 E1 and higher i guess) opens in another tab to create automatically a new form with the fields you have already in your list! If you click back to the previous tab, your list has got 3 or 4 options in that ribbon and thus you can only work within powerapps form, without the modern ribbon. But it is then only a new view to change for your list view. Pls. check and see the different views then in the top right of that list view and change back to "all items".

 

You can find your form settings in clicking on the gear -> LIst settings -> Form Settings.

 

There you can also change back to the default aspx form if you dont like your powerapps form. But I highly recommend this in every case because then you can decide, whitch action is performed on which button you created it for.

 

Thus no excel export button, if you don´t want it.

 

Greets, Eva.

Highlighted

@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.