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:
@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
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.
@Jorddrick
Can you tell us how do you output the 3 tabs for one Excel?
If directly by sheet names, that might cause the file locked as well.
We normally use this one I think.
The original output:
second tab that I am trying to add to that output using a different tab name of course.
@Jorddrick
@christine_assaad shares the same with my previous snapshot, we should use the function of output tool for multiple worksheets.
Hi @Jorddrick
Do you write into one excel file by some Output Data tools?
If then, you can use Block Until Done tool.
You have to insert them before Output Tool.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |