SAP Knowledge Base Article - Preview

1997339 - EPM Add-in: BPC Protected reports do not allow users to perform specific actions


  • 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


SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver


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.