u201CYour range has been reducedu201D problem

[Former Member]

Hello!

I really need help u2013 Iu2019m using Xcelsius 2008. Since Iu2019m using formulas in my spreadsheet I have a warning message u201CYour range has been reduced to the maximum rows allowedu201D. I know it because I checked what happened if they are no formulas.

The formulas are for dynamic drill in charts.

At first it didnu2019t bother me since Iu2019ve seen all the data that I wanted, but now Iu2019m not seeing all the data. My main tab of the spreadsheet has around 100 rows and A-BE columns.

My question: How can I solve this?

Thanks!

Guy

[Former Member]

BTW - i tried the "preference > excel options" trick and it didnt work - i put 5000 rows and still the message is shown.

although now i see the missing data, how can i really be sure there is something missing?

thanks!