Managing 'Exceeding file size limit' error

Question

Hi,

My workflow results in about 685k rows (as shown while workflow runs) and about 25-30 columns. However when i add a .xlsx file as Output it shows the below error message. I have previously had more rows than this as output, so not understanding what might be the issue with this workflow. Can someone please help?

Capture.png

mbarone · Accepted Answer

As far as I know, XLSX should be able to handle up to 1 million records.  Although maybe it's more of a total size limit so even if it's less than 1 million, but over a certain number of megabytes it won't be able to handle it.  Try CSV just for the heck of it.  If that works just fine, then you know it's the total file size that's giving you the issue.  If you get an error with the CSV too, then something else is going one with the data itself.