Symptom
- 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.
Read more...
Environment
- SAP Business Planning and Consolidation 10 for NetWeaver
- EPM Add-in 10 for Microsoft Office any Service Pack
Product
SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP NetWeaver 7.3
Keywords
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.