- 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.
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 pageThis 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.