Feb 12 2019 02:37 PM
Feb 12 2019 02:37 PM
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.
Feb 12 2019 11:13 PM
Feb 13 2019 01:05 PM
Are you talking about this feature ? Because i disable it and no luck. I try to the read permission as well and nothing......
Feb 14 2019 02:04 AM - edited Feb 14 2019 02:10 AM
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.
Nov 12 2021 02:51 AM
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