topic Re: How to see the data in excel in QlikView

How to see the data in excel

sreeni_qvd — Mon, 26 Jan 2026 18:19:17 GMT

Hi, I have a data 1300000 (13 Lacks) in straight table, if export data into excel max it's showing 10Lacks records, how can i see the total records in excel, Please let me know

Re: How to see the data in excel

tresB — Mon, 02 Sep 2013 04:46:29 GMT

It is basically beacuse of excel row limit. Different versions of excel have different limits. Excel 2010 -...1,048,576. You can try with excel 2013 (though i am not sure about the limit there).

Re: How to see the data in excel

Mon, 02 Sep 2013 05:12:18 GMT

Hi,

Here is the limitation of different versions of excel .Hope it helps you,

Excel 2007-2010 -> 1,048,576 rows Excel '97-2003 -> 65,536 rows Excel pre-'97 -> 16,384 rows

Thanks and Regards,

S.Amuthabharathi

Re: How to see the data in excel

jagan — Mon, 02 Sep 2013 05:30:53 GMT

Hi,

If you export to excel of straight table data, Qlikview splits into multiple sheets if rows exceeds Excel limit.

For example for Excel 97-2003, in Sheet1 it exports 65535 rows and remaining in the corresponding sheets. You can see the extra data in the next sheets.

Hope this helps you. Please find attached file.

Regards,

Jagan.