Discussion Board for collaboration on QlikView Layout & Visualizations.
i want to ask, is there any limitation in qlikview when we want use "Send to Excel" function?
need for explanation..
i already try but only 65536 row and then change sheet. can i get only one sheet?
When exporting to Excel from QV the data will get split across sheets every 65536 rows even though you use a newer version of Excel that can handle more.
The reason for this implementation is backwards compatibility.
Excel used to have a limit for 65536 rows with their old BIFF format, before moving over to OOXML and support for more rows.
In order to support the older versions, QV exports a maximum of 65536 rows to each sheet when you do a Send to Excel.
Excel limitation is 65536 and beyond this excel take it into next sheet.you can try Csv file.i thing csv has more capacity than excel in one sheet.
Csv can export to only one sheet but excel can export to many sheetas
Its because you are using 2003 version of excel.
Excel 2007 has more storage capability. install excel 2007 and check the difference.
With what procedure you are exporting data to excel.
Can you please send me that application as i dont have application with that hugh data.
Let me check what happens at my side.
Its ok i understand.