1498963 - Error "Your range has been reduced to maximum rows allowed" or “An error occurred during SWF generation. For more information contact the file creator or your system administrator” occurs when there are too much calculations functions such as VLOOKUP and SUMIF

SAP Knowledge Base Article - Public

1498963 - Error "Your range has been reduced to maximum rows allowed" or “An error occurred during SWF generation. For more information contact the file creator or your system administrator” occurs when there are too much calculations functions such as VLOOKUP and SUMIF

Symptom

Error "Your range has been reduced to maximum rows allowed" or “An error occurred during SWF generation. For more information contact the file creator or your system administrator” occurs when there are too much calculations functions such as VLOOKUP and SUMIF.

  • Error "Your range has been reduced to maximum rows allowed" when File > Preferences > Excel Options > "Maximum Number Of Rows" is small
  • Error “An error occurred during SWF generation. For more information contact the file creator or your system administrator” even after File > Preferences > Excel Options > "Maximum Number Of Rows" has been changed to the max
  • There are too much calculations functions such as VLOOKUP and SUMIF
  • The calculation targets of SIMIF are the calculation results of VLOOKUP
  • The calculation targets of VLOOKUP are all rows of Excel such as “=VLOOKUP(J4,A:B,2,0)”
    "A" means all Excel rows of column A, and "B" means all Excel rows of column B

Environment

  • Xcelsius 2008 SP3 FP3.2

Reproducing the Issue

So far issue only occurs in customer report.

Cause

There are too much calculations functions such as VLOOKUP and SUMIF, especially the calculations functions target areas are too huge (such as are all rows of Excel).
Xcelsius can’t handle such huge and complicated data to produce Flash file.

Resolution

Although an similar Enhancement Request has been identified and logged under Enhancement Request ID ADAPT01165536.
For the Xcelsius best practices you should avoid using unless your data is set small:

  • SUMIF
  • COUNTIF
  • HLOOKUP
  • VLOOKUP

For this case only, after change the formula of VLOOKUP from “=VLOOKUP(J4,A:B,2,0)” to such as “=VLOOKUP(J4,An:Bn,2,0)”.
n = the row number that customer confirmed contains data, error doesn’t occur.

See Also

  • Xcelsius 2008 SP3 User Guide
  • Xcelsius Gurus Top 10 Excel Tips For Success
  • Xcelsius 2008 General Best Practices

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008