Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Sharing Workbooks with the Browser
Controlling What’s Visible in the Browser
Excel Services gives you control over which parts of the workbook are accessible through the server
when either viewed through the browser or accessed through the web services API. The benefits of
having this control are as follows:
You can simplify the browsing experience by displaying only the critical parts of a workbook.
For example, you could display a final sales results report, but not all the data and scratch
calculations used to come up with it.
You can secure certain parts of the workbook from the readers. For example, you could display
only an aggregated results table without providing access to all the detailed data on other sheets.
You accomplish this by granting file access rights to the user (as described in Chapter 10).
As you saw in the first example, the entire workbook is visible in the browser by default. By using the
Show tab in the Publish dialog box, you can limit access to specific sheets or specific items in the
workbook. Items can be one or more of the following:
Named ranges (only consecutive named ranges are supported)
The following Try It Out shows you how to control which parts of the workbook are visible in the browser.
Try It Out Controlling What’s Displayed in the Browser
To control what’s visible in the browser, follow these steps:
Start Excel 2007 and load the Sales Report.xlsx workbook that is provided with this topic.
From the Office menu button, select the Publish option to show the Publish fly-out.
Select the Excel Services option.
If you are not continuing from the first example, enter a location where you want the workbook
saved. This must be defined as a trusted location on the server.
Verify that the Open in Excel Services box is checked (which it is by default).
Switch over to the Show tab. By default, the Entire Workbook option is selected, and the list box
below it is disabled.
In the drop-down menu, select Sheets. The list box is enabled and displays the available sheets
in the workbook, as shown in Figure 9-4.
Select the Sales By Reseller Type sheet by checking the box next to it.
Publish the workbook by pressing the Save button.
A new browser window opens with the workbook displayed. This time, the workbook in the
browser has only one sheet tab, Sales By Reseller Type, as shown in Figure 9-5. You cannot
navigate to the other sheets. In fact, there is no way of knowing that the other sheets even exist.