Error with max number of rows (using lookupV)
I'm using Xcelsius 2008 SP3 FP3.5 with live office sp3 fp 3.5.
I hacve configured xcelsius options so the maximum number of rows allowed would be 2000, instead of 512.
I have a webi report with a 1500 rows. I imported it via Live Office in my presentation.
I have several formulas using lookupV. At design mode, it's ok. In preview,
when data is in the first 512 rows, everything is fine. When not, returns #N/A error.
I've tried using other excel functions such as index, match, with the same result.
I've checked at Xcelsius preferences and it is set to 2000 rows.
Xcelsius doesn't warn me about truncate.
Any ideas please??
Thanks in advance!