SAP Knowledge Base Article - Preview

2786124 - Excel formula with references to another cells is changed in the input Schedule on Analysis for Office - BPC NW / EPM Add-in-

Symptom

  • When adding an Excel formula with references to another cells in the input Schedule on Analysis for Office the symbol $ is lost.
  • Example: the formula in the cell is changing from "=VLOOKUP($D3,Sheet3!C3:D6,2,FALSE)" to ""=VLOOKUP(D3,Sheet3!C3:D6,2,FALSE)".


Read more...

Environment

  • SAP Business Planning and Consolidation 10.x, version for SAP NetWeaver
  • SAP EPM Add-in for Microsoft Office
  • Analysis Office

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 7.5, version for SAP NetWeaver ; SAP S/4HANA 1709

Keywords

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, plugin, BPC4HANA, BW4HANA. , KBA , EPM-BPC-NW , NetWeaver Version , BI-RA-AO-XLA , Excel Addin , 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.