Microsoft Office Tutorials and References
In Depth Information
Location
Excel Services can load workbooks only from a trusted location. Listed below are the settings that allows you to
configure a trusted location for your workbooks:
Address: Set the trusted location from which workbooks should be loaded. These can be
any Microsoft SharePoint Foundation or network file share or a web folder address.
Location Type: Choose the storage location type based on the address you set. If the address
is a SharePoint document library, select Microsoft SharePoint Foundation . If the address is a
network share, choose UNC Path . And for a web folder address, select http web site .
Trust Children: Choose whether or not directories or child libraries can be trusted.
Session Management
When a user requests a workbook from server, the server creates a new session and opens the latest version of the
workbook. Note that there may be different users accessing the same workbook; hence, you may have multiple
sessions opened for the same workbook. It’s important to control the resource consumption as well as duration of any
concurrently open ECS sessions. With the help of the following settings, you can manage resource availability and
sessions, which can improve the performance of ECS:
Session Timeout: Set the maximum timeout value (in seconds) for an ECS session to open
and remain inactive before shutting down. This value is measured from the end of each open
request. Valid values are –1 through 2073600 (24 days). If the value is set to zero, the session
expires by the end of each single request. Set the value to –1 for no time out.
Short Session Timeout: Set the maximum timeout value (in seconds) for an Excel Web Access
session to open and remain inactive without any user interaction before shutting down. This
value is measured from the end of the original open request. Valid values are –1 through
2073600 (24 days). If the value is set to zero, the session expires by the end of each single
request. Set the value to –1 to disable the short session timeout.
New Workbook Session Timeout: Set the maximum timeout value (in seconds) for an ECS
session to open a new workbook and remain inactive before shutting down. This value is
measured from the end of each request. Valid values are –1 through 2073600 (24 days). If the
value is set to zero, the session expires by the end of each single request. Set the value to –1 for
no time out.
Maximum Request Duration: Set the maximum duration (in seconds) of a single request in a
session. Valid values are –1 through 2073600 (24 days). For no limit, set the value to –1.
Maximum Chart Render Duration: Set the maximum duration (in seconds) to render a single
chart. Valid values are –1 through 2073600 (24 days). For no limit, set the value to –1.
Workbook Properties
The following values impact the performance and resources of the server. The bigger the workbook size or the chart or
image size, the greater the resource consumption is and, thus, the worse performance is.
Maximum Workbook Size: Set the maximum size (in MBs) for a workbook that can be
opened by ECS. Valid values range from 1 to 2000 MBs.
Maximum Chart or Image Size: Set the maximum size (in MBs) of a chart or image that ECS
can open. Valid values are any positive integers.
 
Search JabSto ::




Custom Search