Hi all,
My Xcelsius data pulls info from a few different worksheets. Recently the data in one of these xcel worksheets has gone over 1500 rows - any info above Row 1500 is now not being pulled on the live exported Xcelsius file.
I have already increased the data limitations in the Properties tab …just wondring if I am missing something? I am tearing my hair out after a week of trying things 
thanks
Eoinc1985 (BOB member since 2010-06-08)
Oh so you are confirming that you have set Excel Options in preferences to refer to more than 1500 rows. (File - Preferences - Excel Options)
Can this be the case that the component is only binding 1500 rows?
Please confirm.
BO_Stuffed (BOB member since 2008-03-29)
Hi,
Yes I have the preferences set to 60000. The thing is it worked up to a week ago.
I use two similar worksheets - both pull similar info and are bound to over 1500 rows. I use the same bind and formulas for both
But 1 worksheet is pulling the info correctly at approx 1300 rows and the other has hit 1500 and I cant see all the info. In fact I am only seeing approx 50 rows of info in the actual project
The overall size of the Xcelsius project ahs alo been bigger so Im just clueless.
Eoinc1985 (BOB member since 2010-06-08)
Hi all,
Can anybody please help with this???
Thanks
Eoinc1985 (BOB member since 2010-06-08)
Hello , I have sucessfully pulled in over 1500 rows of data into Xcelsius (I’m using SP3.1) , I don’t think it’s an issue with Xcelsius unless it’s something to do with the version you are using. I was using a Web service to test this which returned 2000 rows of data.
ianlearmonth (BOB member since 2008-10-22)
Is it static data on the sheet or you are dynamically getting it from other source?
If it is dynamic, you could choose to take a List View compnent and see if the data is really there or some filtering is screwing up the data.
Lastly, pull only that part of data into a new xlf and see if it binds.
Cheers.
BO_Stuffed (BOB member since 2008-03-29)