Error while writing multiple different tab of same excel after using control container

AnkitGarg_1991

I am getting error "Error: Output Data (1): Can't open file: C:\Users\ankitgarg\abcd.xlsx: The process cannot access the file because it is being used by another process. (32).

This error is because I am trying to write same file with two different tabs at the same time however I am using control container which is deciding execution order. Has anyone faces similar situation in past?

Output

Accepted answers

All comments

jdminton

Which Alteryx version are you using?

AnkitGarg_1991

I am using alteryx version of 2024.2.1.122 Patch: 5

caltang

What is the configuration of both Output tools? Can you kindly screenshot them for us?

AnkitGarg_1991

output-1

Output-2

caltang

Nothing seems off about your configurations. Reading your error again, it seems the input file is more likely the culprit rather than your output file.

Please ensure that the file is not opened when you are running your workflow - if your file is hosted somewhere, ensure no one else is opening it as well.

jdminton

@AnkitGarg_1991

Is this the actual error for the output configurations provided?

"Error: Output Data (1): Can't open file: C:\Users\ankitgarg\abcd.xlsx: The process cannot access the file because it is being used by another process. (32)."

I only ask because the file names don't match.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703