SAP Knowledge Base Article - Preview

1920617 - EPMInsertCellsBeforeAfterBlock issue with FALSE value


  • When using the EPMInsertCellsBeforeAfterBlock function containing FALSE value, for example =EPMInsertCellsBeforeAfterBlock("000";"ACCOUNT";FALSE;B1:B2), with Microsoft Excel in another language than English (French for example), the function does not work: the formula returns #VALEUR! in French language.
  • If using the same formula =EPMInsertCellsBeforeAfterBlock("000";"ACCOUNT";FALSE;B1:B2) with Microsoft Excel in English language, the formula works fine.



  • SAP Business Planning and Consolidation 10 for NetWeaver
  • EPM Add-in 10 for Microsoft Office any Service Pack


SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP NetWeaver 7.3


EPMInsertCellsBeforeAfterBlock function, FALSE value, , KBA , EPM-BPC-NW-EXC , Excel , EPM-XLS-FCT , EPM XLS Functions , 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.