Single Output to Multiple Excel Sheets Failing Mid-Write

I have an alteryx flow that uses the "Take File/Table Name From Field" option on the "Output Data" tool and writes to ~30 separate excel sheets one after the other. It successfully outputs about half of the sheets, and then randomly stops with an "Error: Output Data (42): Unable to make final write to FILENAME for By Source.xlsx, Error Win32 Error 1175". Any idea why it's doing this? An image of what I'm seeing is attached. The Black box is just blocking out user information for privacy.

Output

Accepted answers

RikkiLehman

I changed the excel file output to an xls instead of an xlsx and that seems to fix the issue. I've got no idea WHY that fixes it, but there you go.

All comments

JosephSerpis

Hi @RikkiLehman can you try putting a block until done tool before the output tool and see if you still get the same issue?

RikkiLehman

Hi Joseph,

That doesn't fix the issue. This is from a single output toll, not multiple output tools, so the issue is internal to the tool. I changed the excel file to an xls instead of an xlsx and it now works, but I'm very curious as to why that is.

jcardoso

Hi,

changing the output to a .xls wasn't a solution for me, i got another halfway through the output, it works for several tabs but fails in one of them

" Output Data () Unable to open archive for unzipping: ()"

Still looking for a solution, please!

Joker_Hazard

Me too. Did you find the solution?

Thanks

cpapaioannou

The problem is that the error is not consistent. It happens randomly and does not fall under a recognizable pattern. It may happen in 1 out of 500 ranges that we output after a lot of successful runs in the previous days. The only common sense I can find is that the issue appears when the excel output is "stressed" with multiple output sheets/ranges.

Would be glad if Alteryx Support can have a look at this.

haphan_tran

I write a deep dive into this problem in this post. Please take a look at this.
Writing to multiple Excel Sheets in the same files... - Alteryx Community

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703