SAP Knowledge Base Article - Preview

2727262 - EPM Add-in Excel formula referencing cells with values returned from BPC have #VALUE or unexpected behavior

Symptom

  • In your EPM Add-in report/input form values in some cells are showing #VALUE.  These values are calculated through an Excel formula based on a BPC value returned by an EPM function in another cell in the report
  • Cells show unexpected behavior, e.g. not allowing input when they should be.  The behavior is dependent on values calculated through an Excel formula based on a BPC value returned by an EPM function in another cell in the report.
  • The problem is user specific. 

Read more...

Environment

  • EPM Add-in 10

Product

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

Keywords

Input Greyed out #VALUE invalid cell value input disabled context Excel formula , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

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