Microsoft Office Tutorials and References
In Depth Information
Five Key Ways to Use Excel Services
The scenario is straightforward. After you author a workbook, you save it to a document library or file
share, and provide a link to that location. Figure 1-11 shows a workbook being authored in Excel client.
You can send the link to your workbook to others in an e-mail message, through a notification, or
otherwise. Then the recipients just follow the link, and the workbook is calculated by Excel Services and the
results are displayed in the browser.
In the browser, users can manipulate the workbook to explore the data in it. For example, they can sort
and filter data, drill down or up on a PivotTable, or change input parameters that affect calculation.
However, they cannot change the original workbook or values in it. The browser-based rendering looks
true to the original, as shown in Figure 1-12.
This sounds simple, at first, but consider how this is different and better than simply sharing the workbook
through e-mail or by placing it on a file share and having people load a copy of the workbook in Excel.
When a user opens a workbook in the Excel client from an e-mail attachment or from a file share, a copy
of that workbook is downloaded locally. Even if users do not have permission to save over the original
workbook, they can save a complete local copy. The next time the user wants to access the workbook, he
or she may go back to the copy in the e-mail, or to the copy that was saved locally and, by that time the
user is potentially not looking at the correct, updated version of the workbook. The workbook author
may have updated it or made changes in the meantime.