Microsoft Office Tutorials and References
In Depth Information
To reduce the resources consumed by charting, eliminate any unnecessary use of charts. In addition, you
can use the Maximum Chart Size administrator setting at the trusted location level to limit how large the
charts can be. The default value is 1MB.
Client Machine and Browser Speed
In addition to the client connection speed, the perceived responsiveness depends in part on the client
machine and browser speed.
render. Take into account that if a web page has several workbooks, they will all get rendered on the client
machine, thus significantly reducing the perceived performance.
with EWA on it slower than the subsequent pages.
Although the client hardware is usually outside the server administrator’s control, you should take it
into account when estimating and analyzing the response time that your users are experiencing.
In this chapter, you learned about the architecture of Excel Services, its main components, and operational
concepts, as well as how to configure it for best performance. Specifically, you learned the following:
Excel Services is part of Office SharePoint Server, which has one or more web front ends (WFEs),
application servers, and database servers. Shared Services Providers (SSPs) allow the hosting
and managing of parallel logical application servers in a farm.
The main components of Excel Services are the Excel Calculation Server (ECS), Excel Web
Access (EWA) Web Part, and Excel Web Services API. The ECS is deployed on the application
server and is the engine for loading and calculating workbooks. The EWA and the API are
deployed on the WFE and provide the end-user interface and the programmatic interface,
User activity is performed in the context of a session, which provides isolation. The session state
is kept in the ECS memory and is not disclosed to other sessions.
The ECS has caches of recently used objects in memory and on disk for improved performance.
You can control the amount of memory used by the ECS and these caches.
To achieve good performance and make the best use of your hardware, you should be aware
of the various settings that Excel Services has. These settings allow you to tune the performance
according to your needs. In addition, you can improve performance by controlling the way
workbooks are authored and the web pages containing the EWA.
Chapter 4 discusses the Excel features that are not supported on Excel Services. Some workbooks are not
supported on the server, and others are supported in a different way on the server and the client. You will
learn about these features, and how to adapt your workbooks for the best experience on the server.