Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

AnkitGarg_1991
5 - Atom

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?

 

AnkitGarg_1991_0-1750344260298.png

 

6 REPLIES 6
jdminton
13 - Pulsar

Which Alteryx version are you using?

AnkitGarg_1991
5 - Atom

I am using alteryx version of 2024.2.1.122 Patch: 5 

caltang
17 - Castor
17 - Castor

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

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
AnkitGarg_1991
5 - Atom

output-1

AnkitGarg_1991_0-1750426771680.png

 

Output-2

 

AnkitGarg_1991_1-1750426831310.png

 

caltang
17 - Castor
17 - Castor

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. 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
jdminton
13 - Pulsar

@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.

Labels
Top Solution Authors