Excel Calculation Services: Stsadm operations (Office SharePoint Server)
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.
Excel Calculation Services is one of the three components of Excel Services. The role of Excel Calculation Services is to load workbooks, calculate them, call custom code (user-defined functions) and refresh external data. It also maintains the session state for interactivity. Excel Calculation Services maintains a session for the duration of interactions with the same workbook by a user or caller. A session is closed when the caller explicitly closes it or when the session times out on the server.
For additional information about the Excel Services architecture, see Excel Services Architecture (https://go.microsoft.com/fwlink/?LinkId=109271&clcid=0x409).
You can use the Stsadm command-line tool to configure Excel Calculation Services to centrally manage user access to SharePoint document libraries, UNC paths, HTTP Web sites and external databases, as well as configure the Excel Calculation Services use of system resources.
The following table describes the Excel Calculation Services operations.
| Operation name | Description |
|---|---|
Add-ecsfiletrustedlocation: Stsadm operation (Office SharePoint Server) |
Lets an administrator add a file to the trusted location list. |
Add-ecssafedataprovider: Stsadm operation (Office SharePoint Server) |
Lets an administrator add a supported provider type to the safe provider list. |
Add-ecstrusteddataconnectionlibrary: Stsadm operation (Office SharePoint Server) |
Adds a trusted data connection to a library. |
Add-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server) |
Adds a user defined function. |
Remove-ecsfiletrustedlocation: Stsadm operation (Office SharePoint Server) |
Lets an administrator remove a file from the trusted location list. |
Remove-ecssafedataprovider: Stsadm operation (Office SharePoint Server) |
Lets an administrator remove a supported provider type to the safe provider list. |
Remove-ecstrusteddataconnectionlibrary: Stsadm operation (Office SharePoint Server) |
Removes a trusted data connection from a library. |
Remove-ecsuserdefinedfunction: Stsadm operation (Office SharePoint Server) |
Removes a user-defined function from Excel Calculation Services. |
Set-ecsexternaldata: Stsadm operation (Office SharePoint Server) |
Lets an administrator set an external data connection to Excel Calculation Services. |
Set-ecsloadbalancing: Stsadm operation (Office SharePoint Server) |
Lets an administrator define load balancing for Excel Calculation Services. |
Set-ecsmemoryutilization: Stsadm operation (Office SharePoint Server) |
Lets an administrator determine memory allocation for Excel Calculation Services. |
Set-ecssecurity: Stsadm operation (Office SharePoint Server) |
Lets an administrator set security settings for Excel Calculation Services. |
Set-ecssessionmanagement: Stsadm operation (Office SharePoint Server) |
Lets an administrator set session management settings for Excel Calculation Services. |
Set-ecsworkbookcache: Stsadm operation (Office SharePoint Server) |
Lets an administrator set workbook cache settings on disk and in memory for Excel Calculation Services. |