Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Administration of Excel Services
Stop When Refresh On Open Fails — This setting ensures that the workbook loads only after the
data refresh operation succeeds. When you select this check box, users see an error message if
the workbook they attempt to open cannot refresh. You may want to use this setting to prevent
workbooks from loading if the data isn’t current. The default setting is to stop opening the
workbook if the following criteria are met:
The workbook contains a refresh on open data connection.
The data cannot be refreshed during the open operation.
The person opening the workbook does not have the open right to the file. When you
have the right to open a workbook, you can download it from the document library and
view it in the client.
External Data Cache Lifetime — The maximum time (seconds) that the external data cached by the
ECS can be used. If the lifetime value is exceeded, then the external data source is queried for
the data. If the lifetime value is not exceeded, then the cached external data is used to satisfy the
request. Two cache lifetime settings exist: one for automatic refresh operations, and one for
manual refresh operations. Automatic refresh is used when a connection is configured to use
either periodic or refresh on open operations. Manual refresh is when a user forces the data
refresh to occur. The default setting for both Automatic and Manual refresh is 300. The External
Data Cache Lifetime property can have the following values:
-1 — Never refresh again after the first refresh operation.
0 through 2073600 (24 days) — If the cache lifetime setting is exceeded, the ECS issues a
new external data request and updates the cached results. If the cache lifetime is not
exceeded, the request is served results from the cache.
Maximum Concurrent Queries Per Session — The maximum number of external data queries that
can execute concurrently for a session. The default value is 5. The Maximum Concurrent
Queries Per Session property must be a positive integer.
As shown in Figure 7-9, the User-Defined Functions section of the page contains one trusted file location
property setting. The Allow User-Defined Functions setting enables workbooks in the trusted location to
make calls to UDFs. The default setting is to not allow UDFs in the trusted location.
Command-Line Options for Trusted File Locations
You can also administer trusted file locations from the command line. The command-line interface
supports adding and removing trusted locations for each SSP in your farm. Unlike the web page interface,
which inherently knows the SSP that the trusted location belongs to, you must specify the SSP name
when working with trusted locations through the command line.
Two operations are supported for working with trusted locations through the command line: Add and
Remove. Use the Add operation to create a new trusted location. Use the Remove operation to delete an
existing trusted location.