Disable Export to Spreadsheet in SharePoint Custom List

sharepointsharepoint-2007

Is it possible to disable (or remove) the option in a custom list to export to Excel? We have a sensitive list on a team site with a large number of items and views whereby the business sponsor would like people to be able to see the data but not have the ability to pull down into Excel.

Best Answer

You need to define a custom permission level. The easiest way is to copy from one of the default ones.

Once you create your permission level uncheck the following option:

[] Use Client Integration Features

Create a group that has this permission level, and and your users to this group.