Microsoft Office Tutorials and References
In Depth Information
Controlling Workbook Viewing
When users have the View Only permission, they cannot download or open the workbook in the client.
This means that they see only the workbook as it is calculated by Excel Services and rendered in the
browser. A number of options aren’t available to the users in the interface, including the following
options from within the document library:
Edit in Microsoft Office Excel
Sent To: Other Location, Create Document Workspace, and Download a Copy
When you view the workbook in the browser using Excel Services, the Open In Excel option is not
available. You can see this in the following Try It Out. For this exercise, you must have access to a second user
that has the View Only permission (as created in the previous exercise).
Try It Out Viewing a Workbook with the View Only Permission
To view a workbook with View Only permission, follow these steps:
1. Log in to Office SharePoint as the user you created earlier who has View Only permission to the
Sales Reports document library. You can do this by logging into Windows as this user, running
the browser session as this user, or selecting the Sign In As A Different User option from the
SharePoint drop-down menu (see Figure 11-20).
2. Open the drop-down menu for the Sales Report. As you can see in Figure 11-21, you only have
access to server-side options.
3. Click the workbook name in the document library. You will get the Excel Services
browserbased rendering of the workbook, even though the default for this library should be to open
in the client. The default click is now View In Web Browser, because this is what you have
permission to do.
4. Click Open on the toolbar. As you can see in Figure 11-22, you only have access to opening a
snapshot (more on this in the next section). You cannot open the workbook in Excel client.
As you can see, you are confined to working with the workbook calculated and rendered on the server.
This means that you do not have access to the original workbook file, to any of the sheets or ranges the
workbook author did not make viewable on the server, or to the formulas behind the cells. This
provides the security and control necessary to guarantee that users are viewing the sanctioned version of