Output Error

Hello,

I am running a workflow where I am trying to create one excel workbook with three tabs that update from the same flow and it is now giving me the following error:

Error: Output Data (58): Unable to open file for write: Folder/fil name.xlsx - Attempt to open a file that is already open: Folder/fil name.xlsx: The process cannot access the file because another process has locked a portion of the file. (33)

Output

Accepted answers

All comments

Qiu

@Jorddrick
Can you be sure that someone or maybe you is opening the file?

The error inidicates someone is opening the file, which makes it unaccessible for Alteryx.
Try a different file name and we would know

Jorddrick

I closed every input and retried with a different name and it keeps giving me the same error. However, when I run the initial excel output , then delete the connections to that output, I can then run and add the extra tabs without the error. Hope that makes sense.

Christine_Assaad

Hi @Jorddrick

I am including a WF that shows how this could be configured. Hope it helps. Cheers!

Output 3 tabs.yxmd

Qiu

@Jorddrick
@christine_assaad shares the same with my previous snapshot, we should use the function of output tool for multiple worksheets.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703