Skip to Content
Former Member
Jul 17, 2009 at 11:58 AM

BPC 7M SP4 EVDRE missing rows - Error is "1004-Selection is too large.}



On a customer who installed BPC 7 Ms SP4 I have on client Exception log the error:

===================[System Error Tracing]=====================

[System Name] : BPC_ExcelAddin

[Job Name] : clsExpand::applyDataRangeFormula

[DateTime] : 2009-07-17 09:44:13


Detail<sg : {1004-Selection is too large}

===================[System Error Tracing End ]=====================

When I see this error there is an EVDRE input schedule expanding which have some of the rows missing rows descriptions.

This means there is a gap of missing row header formulas stating from second row to somewhere in the middle of the report.

If I reduce the number of the resulting rows for the same EVDRE input schedule results are ok.

Do you know some setting to fix this?

I tried increasing the Maximum Expansion Limit for rows and columns in Workbook Options without success.

Thank you.