Happy Business Starts Here

Why does my Data Export task fail when export as Excel format with error 'Unexpected error'?

Highlighted
Zuora Support Moderator

Why does my Data Export task fail when export as Excel format with error 'Unexpected error'?

Why does my Data Export task fail when export as Excel format with error 'Unexpected error'?

 

Regards,
Yong Xiang | yxiang@zuora.com
Application Support Engineer | Zuora Inc.


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Support Moderator

Re: Why does my Data Export task fail when export as Excel format with error 'Unexpected error'?

If the Data Export result contains more than 1048576 rows of data and export file type is Excel, the task will fail due to the limitition of Excel. The workaround is export it as a csv file.

 

Reference from Excel specifications and limits: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269...

 

Total number of rows and columns on a worksheet

1,048,576 rows by 16,384 columns

 

 

Regards,
Yong Xiang | yxiang@zuora.com
Application Support Engineer | Zuora Inc.


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √