Enable user-defined functions

  • Article

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

In this article:

  • About user-defined functions

  • Enable user-defined functions

  • Enable user-defined functions for workbooks in a trusted file location

About user-defined functions

User-defined functions extend the capabilities of Excel Services in Microsoft Office SharePoint Server 2007 by enabling you to define and create custom functions. To enable this functionality, you need to configure Excel Services to support user-defined functions.

To configure this support, you must enable user-defined functions on trusted file locations containing workbooks that require access to this functionality. In addition, you must register user-defined function assemblies on the Excel Services user-defined function assembly list.

Enable user-defined functions

Use the following procedure to enable user-defined functions.

Enable user-defined functions

  1. From Administrative Tools, open the SharePoint Central Administration Web application.

  2. On the Central Administration home page, click Application Management.

  3. On the Application Management page, in the Office SharePoint Server 2007 Shared Services section, click Create or Configure this Farm's Shared Services.

  4. On the Manage this Farm's Shared Services page, click SharedServices1 (Default). This is the Shared Services Provider (SSP) that you will configure.

  5. On the Shared Services home page, in the Excel Services Settings section, click User-defined function assemblies.

  6. On the Excel Services User-Defined Functions page, click Add User-Defined Function Assembly.

  7. In the Assembly box, type the assembly strong name or the file path of the user-defined function assembly that you want to register.

  8. In Assembly Location, perform the following actions:

    1. Select the global assembly cache (GAC) if you are deploying a user-defined function assembly to the GAC on each Excel Calculation Services application server in your farm.

    2. Select Local file if you want to save a user-defined function to a directory on an Excel Calculation Services application server (a local path), or to a network share (a UNC path).

    3. Ensure that the Enable Assembly check box is selected, and then click OK.

      For information about how to perform this procedure using the Stsadm command-line tool, see Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server).

Enable user-defined functions for workbooks in a trusted file location

Use the following procedure to enable user-defined functions for workbooks in a trusted file location.

Enable user-defined functions for workbooks in a trusted file location

  1. In the Excel Services section of the Shared Services Administration home page, click Trusted file locations.

  2. On the Excel Services Trusted File Locations page, click the URL of the trusted file location whose properties you want to edit.

  3. In the User-Defined Functions section of the Excel Services Edit Trusted File Location page, select User-defined functions allowed, and then click OK.

    For information about how to perform this procedure using the Stsadm command-line tool, see Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server).

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable books for Office SharePoint Server 2007.