SAP Knowledge Base Article - Preview

2356299 - Error "Range #0 has exceeded workbook columns limit, 255"

Symptom

When the user expands the EVDRE reports in EPM Add-in, they got an error message “Range #0 has exceeded workbook columns limit, 255” in the EPM log file. The columns max is 255 but the actual columns that the report using is below the max number e.g. the report only has  17 columns (ending at Q).

It appears the report mis-counts the row number into column number. For example, the report has 357 rows and 17 columns, but in the EPM Log it says “Range #0 has exceeded workbook columns limit, 255. The expanded size is 357”.

LOG_KBA.PNG

 


Read more...

Environment

Business Planning and Consolidation 10.1, version for NetWeaver

EPM Add-In 10.0

 

Product

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP NetWeaver 7.4

Keywords

KBA , 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.