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 , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem