Export to Excel limitation from a table

[kkkumar82]

Hi Qlikers,

I know that there is a limitation in the number of rows when we are exporting to Excel, I  just want to confirm whether it is solved in any of the recent releases.

I actually want from a straight table and pivot table title icon not from macros.

How ever is this problem can be solved using macros

Thanks

Kiran Kumar

[pokassov]

Hello!

1. Help->About QlikView->right mouse on icon->

RowLimitForCsvInsteadOfXls

and change limit.

I think you can do it in macros also

[kkkumar82]

Thanks Pokasov I found this suggestion earlier but it didn't help me, after 65K records the file is converted to CSV and it is taking much time to convert it.

Thanks

Kiran Kumar

[awhitfield]

Hi Kiran,

can you not just open the resultant .csv in a later version of excel?

Andy

[kkkumar82]

Thanks for your idea, infact the exporting into csv is taking longer time, that it is a mash up application.

Thanks

Kiran Kumar