disable Excel export on costume list
hi all, is it possible disable Excel export on costume list? if yes how can do it?
May 21st, 2010 4:09pm

You can create a new custom permission level. With the least required rights for users who will be accessing the Custom list and make sure you deselect the Use Client Integration Features permission level. Create a new group that has this permission level, and add your users to this group. Followed by breaking the permission inheritance for that list and remove all group you can keep the owners members and other group who should have the Export to SpreadSheet option. And add the newly created Group to it. Now the users who are added to the new group will not get the Export to SpreadSheet option. Hope that helps. -Mukesh
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2010 4:24pm

Hi, For this, there is a feature available in codeplex: Toolbar Manager This Feature allows you to selectively show and hide menu items on the standard list/library toolbar. The feature adds a new web part to the gallery that you can place on any list/library view page. Once placed on the page, you can use the properties of the web part to show or hide menu items. This is the perfect solution for hiding a single menu item such as “Export to Spreadsheet” to prevent users from taking that action. More information: http://features.codeplex.com/ Regards.
May 21st, 2010 5:30pm

Rohit, As i have never evaluated the above, Will this remove the Export to Spreadsheet option completely from all libraries or you can provide remove from specific libraries and also choose which users/groups should have the option and the ones who cannot. If it completely removes the option for everyone, than there's even a better approach, in Central Administration drill Down to Central Administration > Application Management > Authentication Providers [Choose your Application] > Click on the Default zone. On the Edit Authentication Page disable Client Integration and Click Save. But for your info it will also disable/remove the following too, completely from all Library. Edit in Datasheet Open With Windows Explorer Export to Spreadsheet -Mukesh
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2010 8:08pm

Hi Mukesh, Toolbar Manager will remove the option from a specific list view web part only i.e. from a single page on which it has been added. In the "Advanced" section of this web part "Target Audiences" option is present but however it doesn't work (tried on my m/c). Other option will be to use javascript to hide these options, one can insert the javascript in a content editor web part and "Target Audiences" the web part so that it will hide the options from specified users/ groups only. e.g. <script type="text/javascript"> _spBodyOnLoadFunctionNames.push("hide"); function hide() { hideListViewToolbarItems("list settings","document library settings","create column","open with windows explorer"); } function hideListViewToolbarItems() { .............. } </script> For complete function hideListViewToolbarItems() refer below link: http://stackoverflow.com/questions/1166148/hide-new-actions-upload-settings-menus-in-sharepoint-lists-document-libra Disabling client integration is not advisable as it will turn off many other options too. More information : http://msdn.microsoft.com/en-us/library/bb977430(office.12).aspx ( check Integrating with the 2007 Microsoft Office System section) Hope this helps. Regards.
May 22nd, 2010 3:36pm

This is incorrect. It disabled Visio integration etc but still allows user to export to Excel.The world is the mollusc of your choice
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2010 3:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics