Symptom
- 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.
Read more...
Environment
- SAP EPM solutions, Add-in for Microsoft Office 10.0
- EPM Add-In 10.0
Product
SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver
Keywords
KBA , EPM-XLS , EPM Excel Client , EPM-XLS-SEC , EPM XLS Security , Problem
About this page
This 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.