Microsoft Office Tutorials and References
In Depth Information
With workbook protection , you can lock the workbook structure and windows. When the workbook
structure is locked, users cannot add or remove worksheets or display hidden worksheets. When the windows
are locked, users cannot change the size or position of workbook windows.
To set up workbook protection in Excel, click the Review tab, click Protect Workbook, and select Protect
Structure and Windows. You can optionally specify a password required to remove the workbook
Workbooks with structure or windows protection are not supported on the server. Excel Services will not
open them, even if they don’t have a password associated with the protection.
Excel Services does not have features to allow users to add or remove worksheets, display hidden
worksheets, or change the size and position of workbook windows. Therefore, workbooks opened in EWA are
implicitly protected, as long as they are viewed on the server.
By using sheet protection , you can limit the changes users can make to a worksheet. For example, you can
lock certain ranges for modifications, as well as limit the insertion and deletion of rows and columns; the
formatting of cells, rows, and columns; filtering; and sorting.
To protect a worksheet, click the Review tab, click Protect Sheet, and select the features you want to
protect. You can optionally specify a password required to unprotect the workbook. When the worksheet is
protected, any attempt to do any of the locked operations will result in an error in Excel.
A workbook with worksheet protection will fail to open in Excel Services, even if there is no password
specified. Excel Services has a number of features to define the types of changes that users can make in
By default, users cannot edit cells in EWA. You can specify workbook parameters when publishing a
workbook to the server, and users will be allowed to modify only these parameters. Follow these steps:
Mark the cells that you want to allow users to modify as named ranges.
Click the Office button, click Publish, and select Excel Services.
Click Excel Services Options, open the Parameters tab, and click Add.
Use the parameters task pane of EWA to set the values of the parameters.
Several of the protected features are not supported on Excel Services, so they are implicitly protected.
These are formatting cells, rows, and columns; inserting and deleting rows and columns; inserting
hyperlinks; editing scenarios; and editing objects.
You can limit sorting and filtering and other interactivity features at the individual EWA instance by
customizing its settings. In the browser, click Modify Shared Web Part from the Web Part menu, and check
the relevant options.