Excel 2010 record number is limited to 65536?

[#1]

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.

[ecolomer]

Yes, you can export to format csv in order to don't have limit

[MarcoWedel]

At least this should not be a limitation of excel.

This excel version should support up to 2^20 rows.

regards

Marco

[Peter_Cammaert]

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?

[#5]

Save it as an xlsx file rather than xls, this will then give you the 1m rows.