I have question regarding RowLimitForCsvInsteadOfXls in Qlikview. I have changed RowLimitForCsvInsteadOfXls on 500 000 (1 048 576 value), but my excel creates sheets - first one has 65536 and remaining rows moves to second sheet. But I have to see all records only in one sheet (I have excel 2010). Do you know why excel do that, if 2010 v. has 1048576 rows limitation. And if i would like to do the same on server and see report in access point, should I do the same?
That's because of backwards compatibility. Earlier versions of Excel did not support more rows, so they remaingin rows needed to be put on the other sheets. You can't use the builtin export functionality to get all the records on the same sheet. That requires a macro. Or you can simply accept csv output as export format instead and open the csv file in excel.
On the server you can put the RowLimitForCsvInsteadOfXls setting in the settings.ini of QVS.
