SAP Knowledge Base Article - Preview

2635990 - AO sheet protection can't be removed - SAP BPC FOR SAP NETWEAVER


Customer created a workbook using the SAP Analysis for MS Office version 2010. The workbook has one EPM sheet (based on the EPM plugin) and 2 Analysis sheets (based on the Analysis plugin). Worksheet protection was implemented via the SetSheetOption api using the following VBA code:

api. SetSheetOption "sheet name",300, True, "password", 20592

All sheets get protected (EPM sheets and AO sheets).

When executing the following sheet protection removal code:

api. SetSheetOption "sheet name",300, False, "password"

The code does not remove the protection from the Analysis plugin based sheets and customer is unable to change workbook and data source level settings. EPM sheets do get unprotected.



  • SAP Business Planning and Consolidation version for SAP NetWeaver
  • SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver


SAP Business Planning and Consolidation, version for SAP NetWeaver all versions ; SAP ERP 6.0


EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC , KBA , BI-RA-AO-BPC , Please use component BI-RA-AO-XLA , EPM-BPC-NW , NetWeaver Version , 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.