Microsoft Office Tutorials and References
In Depth Information
Chapter 13: Offloading Workbook Calculation to the Server
Calculation to the Server
There are many scenarios in which you need to offload workbook calculation to the server. You may
have workbooks that take a significant amount of time to calculate, and you can free up the client
machines and specifically the end user’s desktop by moving the calculation to the server. You may
need to run multiple scenarios or parameters through a workbook and, although a single workbook
calculation may not take long, iterating through thousands of parameters with that workbook may.
This chapter discusses these scenarios. It focuses on the setup and configuration considerations, as
well as describing a few sample solution designs. Because there is no out-of-the-box functionality
for offloading calculations, you need to write some custom code to create a solution that does this.
You learn about the Excel Services API in the Chapter 14, so the actual code sample for one
calculation scenario is in that chapter instead of here.
In this chapter, you learn about the following:
The benefits of offloading workbook calculation to the server
Setup and configuration considerations
A few example solution designs
Integrating with Windows Compute Cluster Server 2003
In general, Excel Services does not calculate a single workbook any faster than Excel client. In fact,
if you take into account the network overhead, the need to send messages across boxes, and other
factors, a single workbook usually calculates slower on the server than on the client. The value of
moving a calculation to the server is not to make it faster, but rather to free up the end user’s
desktop machine so that he or she can continue working.