Send to Excel Limitation Row

[marcohadiyanto]

Hi all,

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?

Regards,

Marco

[SunilChauhan]

hello macro,

                   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

thanks

Sunil

[marcohadiyanto]

Hi sunil,

excel can only 65536 row? but when i create new excel file then i copy and paste, excel can over than 65536 row.

btw my name marco, not macro.

thanks,

Marco

[kaushiknsolanki]

Hi,

    Its because you are using 2003 version of excel.

    Excel 2007 has more storage capability. install excel 2007 and check the difference.

Regards,

Kaushik Solanki

[marcohadiyanto]

hi

i use Excel 2007 with Qlikview 10.

any one ever try this?

thanks,

Marco

[kaushiknsolanki]

Hi,

   With what procedure you are exporting data to excel.

Regards,

Kaushik Solanki

[marcohadiyanto]

Hi,

i use qlikview 10, make straight table, and then click "Send to Excel".

after then excel comes up, my straight table become 3 sheet excel.

Thanks,

Marco

[kaushiknsolanki]

Hi,

    Can you please send me that application as i dont have application with that hugh data.

    Let me check what happens at my side.

Regards,

Kaushik Solanki

[marcohadiyanto]

Hi,

     sorry i can't give you my application..

still confuse bout this..

Thanks,

Marco

[kaushiknsolanki]

Hi,

   Its ok i understand.

Regards,

Kaushik Solanki