Export to Excel

[#1]

When I press send to excel, if the number of records are more than 65000 it creates a csv. I am using office 2007 with Qlikview 11.20 64 bit.

Since excel has a larger capacity how can we make it export larger data sets directly to excel.

Thanks.

[#2]

Hi

This is gwassenaar answer:

There's a setting that you can change to increase the limit before the data is exporting in csv format:RowLimitForCsvInsteadOfXls

On the server you can change the limit in the QVS settings.ini file

[Settings 7]

RowLimitForCsvInsteadOfXls=65500

In Qlikview Desktop you can change this with an 'easter egg' setting. In the Help menu select About Qlikview. Then right click on the Qlikview icon in the lower left corner. Find the entry RowLimitForCsvInsteadOfXls. You can then increase the value from 65500 to a higher number. Note, this may cause a performance penalty on your server.

http://community.qlik.com/message/405762#405762