SAP Knowledge Base Article - Preview

3318626 - Local Member Formula Displayed Instead of Value in Offline Distributed Excel (.XLS) Files - EPM Add-in

Symptom

  • After successful report distribution, when opening the generated report files in offline mode in Microsoft Excel, local member values are not displayed correctly.
  • Instead, the system displays the formula definition of the local member rather than the calculated value.
  • This issue does not occur in earlier versions of Microsoft Excel.


Read more...

Environment

  • EPM add-in 10.0 SP 38.
  • SAP Business Planning and Consolidation 10.x, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 11.x, version for SAP BW/4HANA
  • SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

Product

SAP Business Planning and Consolidation, version for SAP NetWeaver all versions ; SAP EPM all versions

Keywords

EPM Add-in, Offline Distribution, Excel, Excel 2003, XLS, Office 365, Local Member, Formatting Sheet, Format Cells, Formula Display , 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.