Sometimes this button has got to go.

I have a user who doesn’t want to make edits in the SharePoint list.  He exports the list to Excel, makes his edits there, and then forces others to manually update the list with his edits.  No more.

I tried using F12 and writing CSS code to do the trick but it wasn’t working.  As usual, Google led me down many paths, most all of which were either over-the-top (write a solution in C# and deploy) or they just didn’t work.  I finally found the one that worked and I confess, I wouldn’t have written the code like that.  So I’m glad Wendy Li is smarter than I am.

Here’s the solution:

Edit the Page.  Add a Script Viewer web part, then paste in the following code:

<style type="text/css">
 
a[id*='ExportToSpreadsheet']
{  display:none;}
 
</style>

Copyright secured by Digiprove © 2017 Douglas Spicer

Acknowledgements: Wendy Li, Microsoft TechNet Contributor

This entry was posted on October 25, 2017 at 1:49 pm. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Posted in SharePoint 2013 by Doug Comments Off on Hide/Remove the “Export to Excel” button