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

SAP EPM Add-in for Microsoft Office

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 , EPM-XLS , EPM Excel Client , 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.