Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Sharing Workbooks with the Browser
There is now a new drop-down menu on the EWA toolbar. The menu has one entry, RegionalSalesTable.
If you had selected multiple items in step 13, they would all appear here. You would be able to toggle
between the various items (charts, tables, ranges, and PivotTables) by using this drop-down menu.
How It Works
What’s actually happening behind the scenes when you publish a workbook with only specific sheets or
items checked as visible? The most important thing to realize is that the entire workbook is saved to the
server. This is critical for the following reasons:
The visible areas may refer to values and calculations in the nonvisible areas.
It allows you to continue to develop and edit a single workbook file.
The workbook file you saved to the server contains the list of visible sheets or items you selected. When
the ECS loads the workbook, it reads this list and returns only those sheets and items to the EWA, which
renders them to the browser.
When you open the workbook in Excel (assuming you have permission to do so), the entire workbook is
displayed, including all the sheets and all the items. To see which sheets or items are visible when the
workbook is published, open the Publish dialog box or the Excel Services Options dialog box that is in
the Server Properties fly-out and look at the list in the Show tab.
To completely secure the sheets and items in the workbook that you do not want to give access to, you
must limit the workbook users’ rights.
Other Ways to Save Your Workbook to the Server
There are a few additional ways to save a workbook to the server. Although using the Publish dialog box
is the most straightforward method, you may prefer one of the alternatives.
First, you can simply use the Excel Save or Save As function. There is no difference between a workbook
file saved to the server with the Publish option or one of these. They all load workbooks on the server,
which are then viewable in the browser. The Publish dialog box provides the additional functionality of
being able to set viewable sheets or items, define workbook parameters (discussed in Chapter 10), and
automatically open the browser page to view the published workbook. You achieve the same results by
saving the workbook the server using Excel’s regular Save functionality, and then using the Excel Services
Options dialog box under the Server Properties fly-out. This dialog box lets you access the Show tab, as
well as set workbook parameters. However, it does not have an option for opening the workbook in the
browser — you have to do this manually.
You can also upload a workbook file to SharePoint from the SharePoint web UI.
Try It Out Uploading a Workbook to SharePoint
To upload a workbook to SharePoint, follow these steps:
Start your browser and navigate to the Office SharePoint Server home page of your server,