- When protecting an active worksheet in the EPM - Sheet options Protection tab, users are not able to perform specific actions, even if all items are selected:
- The actions are:
- Use Excel formula (such as add, multiply, subtract, etc.) in any cell outside the report area
- Create auto filters
- Create Pivot Table
- Write comments
- Error message issued:
The cell or chart that you are trying to change is protected and therefore read-only.
To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password.
- SAP EPM solutions, Add-in for Microsoft Office 10.0
- EPM Add-In 10.0
KBA , EPM-XLS , EPM Excel Client , EPM-XLS-SEC , EPM XLS Security , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.