![](drpdown.gif)
![](drpdown_orange.gif)
![](collapse.gif)
![](exp.gif)
![](collall.gif)
![](expall.gif)
![](copycode.gif)
![](copycodeHighlight.gif)
Set-ecsworkbookcache: Stsadm operation (Office SharePoint Server) | |
![]() ![]() |
Stsadm command-line tool (Office SharePoint Server) > Stsadm operations (Office SharePoint Server) > Excel Calculation Services: Stsadm operations (Office SharePoint Server) > |
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.
Operation name: Set-ecsworkbookcache
Description
Lets an administrator set workbook cache settings on disk and in memory for Excel Calculation Services.
This operation is equivalent to the Workbook Cache user interface setting that is located on the Excel Services Settings page of the Shared Services Administration Web site.
Syntax
stsadm -o set-ecsworkbookcache
-ssp <SSP name>
[-location {URL | UNC}]
[-maxcachesize <storage in MB>]
[-enablecachingofunusedfiles {True | False}]
Parameters
Parameter |
Value |
Required? |
Description |
ssp |
A valid SSP name, such as "SharedServices1" |
Yes |
The name of the SSP that provides the resources for the Excel Calculation Services you want to configure. |
location |
A valid location to the folder that is trusted Valid values are:
|
No |
Local file system location of the workbook file cache. If the parameter does not contain a value, the cache is located in a subdirectory in the system temporary directory. The maximum length is 4096 characters. |
maxsizecache |
A valid positive integer |
Yes |
Maximum disk space, in MB, that can be occupied by the workbooks that are currently in use by Excel Calculation Services. This parameter also includes the maximum disk space that can be allocated for recently used files that are not currently in use. The default value is 40960. |
enablecachingofunusedfiles |
One of the following values:
|
Yes |
True: Enables the caching of files that are no longer in use by Excel Calculation Services sessions. False: Disables the caching of files that are no longer in use by Excel Calculation Services sessions. |