Excel export issue for Adhoc reporting

[MEDHA07]

Hi All,

I have a report with vizlib table which will work based adhoc selections.I have multiple options and based on selction table will enable the fields and display the data.I have 196 total fields added in table and for each selection 136 field will be enabled.where i have more than 50k rows of data export taking is longer time and after some time getting page error or not enough space memory and close the other tabs ,Aws snap message and sometimes getting permission error.

Mostly this error occuring for adhoc selections and more fields were added in the table.

Now i need help to get my report in excel faster way download.is there any extension or any performance suggestions.

Thanks for reading!

[MEDHA07 · Accepted solution]

Finally after R&d at server level and excel file support 

I have got confirmation the excel has a limitation with 32 Millions cells for combination of coulmns and rows.

Max 80 fileds and around 3 L rows

Or 80 plus fileds and rows should reduce