topic Export to Excel in QlikView https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/557650#M1130869 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Since excel has a larger capacity how can we make it export larger data sets directly to excel. </P><P></P><P>Thanks. </P></BODY></HTML> Wed, 11 Dec 2013 08:54:48 GMT 2013-12-11T08:54:48Z Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/557650#M1130869 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>Since excel has a larger capacity how can we make it export larger data sets directly to excel. </P><P></P><P>Thanks. </P></BODY></HTML> Wed, 11 Dec 2013 08:54:48 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/557650#M1130869 2013-12-11T08:54:48Z Re: Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/557651#M1130870 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>This is <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/gwassenaar">gwassenaar</A></STRONG> answer:</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">There's a setting that you can change to increase the limit before the data is exporting in csv format:<SPAN style="font-weight: inherit; font-style: inherit; font-family: Arial; color: #737373;">RowLimitForCsvInsteadOfXls</SPAN></P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">On the server you can change the limit in the QVS settings.ini file</P><P></P><P style="font-family: Arial; color: #737373;">[Settings 7]</P><P style="font-family: Arial; color: #737373;">RowLimitForCsvInsteadOfXls=65500</P><P></P><P style="font-family: Arial; color: #737373;">In Qlikview Desktop you can change <SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit;">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.</SPAN></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/405762#405762">http://community.qlik.com/message/405762#405762</A></P></BODY></HTML> Wed, 18 Dec 2013 18:49:37 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/557651#M1130870 2013-12-18T18:49:37Z