Show TOC

Worksheet ProtectionLocate this document in the navigation structure

To prevent a user from changing, moving, or deleting important elements of the report, you can protect the current worksheet or the whole workbook. You can also protect certain elements of the current worksheet or workbook, with a password.

Note
  • Even if a worksheet or workbook is protected, you may be able to insert certain members in the report, provided that member insertion filters have been defined. For more information on how to insert members, see Member Entry Using the Insert Members Dialog Box.
  • If you protect a worksheet containing reports in which a user will enter data, you can either lock or unlock a selection of cells of the report. For more information, see Dynamic Formatting Template Definition.

To protect the sheet, the workbook, or only certain elements, enter a password by selecting Start of the navigation path EPM Next navigation step Options Next navigation step Sheet Options End of the navigation path, then select the Protection tab.

You can specify if you want to be able to edit the context options using the Context Options dialog box, when a worksheet is protected. Use the option Edit Context Options. This option is selected by default. For more information on context options, see Context.
Note For details about the other elements you can protect, see the Microsoft Excel documentation.
Tip If you lose the password, you can no longer access the protected worksheet or workbook.
Note When you change a workbook to an offline workbook, the worksheets are automatically protected. For more information about offline mode, see Offline Mode.
To unprotect a worksheet or workbook, select Start of the navigation path EPM Next navigation step Options Next navigation step Sheet Options End of the navigation path. A message appears in which you can enter the protection password. In the Protection tab of the Sheet Options, select No Protection.
Note The Microsoft Excel sheet protection always overrides the EPM plug-in sheet protection. You can unprotect a sheet using the Microsoft Excel feature or the EPM plug-in feature. However, to protect a sheet, you must use the EPM plug-in feature.