SAP Knowledge Base Article - Preview

2041008 - Excel formula cell is not shifting after a new member is added to the BPC report


  • When manually adding a new member on a report (action that also adds a new column to the report) the Excel formulas are not shifted to the next cell as one expects. The cell references become invalid.
  • The same behavior can be reproduced on different EPM Add-in SPs and Patches.
  • Example:
    • Excel formula added to cell E6 to calculate 2006.TOTAL


    • New member inserted


    • The formula was not shifted to cell F6 as expected. Note that in this case the formula is still referencing 2006.TOTAL (now on columns F) because sheet option "Keep Formulas Static that Reference Report Cells" is unchecked. 




SAP BusinessObjects EPM solutions, add-in for Microsoft Office 10.0


SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver


KBA , best practices , EPM-XLS-REP , EPM XLS Reporting , 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.