We have developed a Z report which i am trying to download in Excel.The report is huge one having 1 lakh line items.When i download the report not all the line items are downloaded in excel.
In excel the max rows are 65536 so my question is why a additional sheet is not created to download the entire report.
Is there a way to download the report completely in excel. Are there any setting to be made in excel?
I have excel .xls having 65536 rows as well as Excel 2007 .xlsx having 1048576 rows.