How much Data can be exported to excel through Macro ?

[#1]

Hi All ,

I tried to export the data through the macro but the process is going endless . I have around 20 lacs records * 20 columns pivot chart whom i need to export to excel .

I tried with Quarter on Quarter export but it is taking 8 hours to complete its operation.

Is there any alternative method to automate this which takes less time.?

regard

Rajdeep

[fernandotoledo · Accepted solution]

cant you do it in script? now you can use STORE commands with other formats as csv.