Microsoft Office Tutorials and References
In Depth Information
Caching plays an important role in providing quick response time for user requests. Here are the options to control
the caching behavior:
Workbook Cache Location: Set the location of the file system hosting the ECS server
where workbook files are cached. If the location isn’t set, the subdirectory under the system
temporary directory will be used.
Maximum Size of Workbook Cache: Set the maximum workbook cache (in MBs) that
ECS can use on the disk. This value also counts for recently used files that are currently not
opened. Valid values are any positive integers.
Caching of Unused Files: If you need to cache files that are unused in any session by ECS,
select the Caching Enabled check box.
Here are the options available to control the external data access behavior of Excel Services:
Connection Lifetime: Set the external data connection lifetime. Valid values are –1 and
0 through 2073600 (24 days). In the event of new queries, older, expired connections are
reopened. If no connections are to be closed or reopened, set the value to –1. It is highly
recommended you limit this value to reduce the risk of a denial-of-service attack.
Unattended Service Account and Application ID: Set the Unattended Service Account ID
for single sign-on using the Secure Store Services application. The Application ID must be
preconfigured in the Secure Store Services application. You’ll learn how to configure Secure
Store Services shortly in the “Excel Services and SSAS” section.
Trusted File Locations
Remember how you used SSP in MOSS 2007 to make an Excel file location trusted? By default, all SharePoint
(Microsoft SharePoint Foundation) locations are trusted. However, administrators can set rules to protect or unprotect
specific file locations. Click on Add Trusted File Location (Figure 5-6 ) to add and configure trusted file locations.
Figure 5-6. Excel Services Trusted File Locations page
Search JabSto ::