SAP Knowledge Base Article - Preview

2546415 - #REF! with EPM function EPMCopyRange - EPM Add-in


You use the EPM function EPMCopyRange to repeat the content of a source range of cells until the bottom (columns) or the right side (rows) of a report is reached.

However, after the first refresh, the target range of cells cannot retrieve data. Instead, it shows #REF!

If you refresh again, the target range of cells can retrieve data.



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


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


EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, refresh twice, refresh two times, refresh again, second refresh , KBA , reporting , EPM-BPC-NW , NetWeaver Version , EPM-XLS-FCT , EPM XLS Functions , How To

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.