I have a data set with 10000 plus rows, however 10,000 plus rows have only 4 distinct values.
How do I show distinct values in Combo Box, when I select range from $A$1:$A$10001, I get error message that ranges is greater then the allowed max range.
Thanks in Advance.
irehman (BOB member since 2007-12-01)
What if you select the insert type tp filtered rows?
Thanks,
Zaif
zaif235 
(BOB member since 2010-06-15)
Download the Distinct List Component at http://www.xcelsiuscomponents.com
Aeron 
(BOB member since 2011-07-09)
Hi
U have to set excel preferences.
File->preferences->excel options->Change the max no. of row to 10000.
Now it wil work…
Yogisha
yogishag 
(BOB member since 2011-04-20)
Store your 10,000 rows at database level. Then fire the appropriate SQL to generate a distinct list of values to return to the user. Bind these values to a small range on your xclesius sheet. Depending on which one your user selects, build your SQL as appropriate to get the correct dataset back.
Basically you will get the best out of xcelsius if you use it to display your data and control user interaction, but not to actually store the data.
debbie
Debbie 
(BOB member since 2005-03-01)
You could also look at BIWS (Business Intelligence Web Service), from within Webi Rich Client.
Mak 1 (BOB member since 2005-01-06)