Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all:
I export about 100 thousands record to excel 2010, but 65536 records is limited in one sheet. What's that wrong? I use QV 10 SR2 and Excel 2010.
Yes, you can export to format csv in order to don't have limit
At least this should not be a limitation of excel.
This excel version should support up to 2^20 rows.
regards
Marco
Why is it that a post/question dated Auguts 2011 suddently pops up at the top of the discussions overview as if it had been submitted 5 minutes ago? Problems with the Jive code?
Save it as an xlsx file rather than xls, this will then give you the 1m rows.