Format of exported data changes to text if resulting Excel sheet exceeds 65536 rows by 256 columns

[Sonja_Bauernfeind]

When trying to Send data of a QlikView object that has above 65536 rows by 256 columns, to Excel 2010 Worksheet file,  the file converts into .CSV extension, and the numeric data is getting converted into Text format. How to overcome this problem?

Steps to reproduce the problem: 

1. Open the attached qvw file.

3. Right click on object>Send to Excel 

Because of Excel 2010 limitation, you cannot export above 65536 rows by 256 columns to Excel worksheet, hence the file converts into .CSV  format.
Ref. http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Resolution:

Export to XLSX instead.

Environment:

QlikView