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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.