The process cannot access the file because it is being used by another process

Hello! Very new to Alteryx here.

I'm getting another error when I run my workflow (attached below):

Error: Output Data (8): Can't open file: G:\Shared drives\Vigilant Solutions, LLC_Finance Folder\ADMIN\Month End Close\Vigilant Analysis Support\Weekly MSI Report\2023\11-November 2023\Vigilant Weekly Reporting - New.xlsx: The process cannot access the file because it is being used by another process. (32)

Can someone please take a look at my workflow and help to explain what the issue might be? I tried looking on other discussions and couldn't really find a solution. I know for a fact I'm the only one accessing the output files.

LPR - Revenue Visibility Workflow.yxmd

Error Message

Accepted answers

SPetrie

You are trying to write to the sheet in the output of one part of the workflow and read it in in another part.

How are you trying to use the data? if the output of the first is the same as the input of the second, connect the end of that first flow instead of using a file input. That way you are not fighting yourselft. The workflow has the file open, so you cannot write to it at the same time.

All comments

SPetrie

You are trying to write to the sheet in the output of one part of the workflow and read it in in another part.

Qiu

@jershon26
As pointed out by @SPetrie We should try to avoid to output the data to Excel file and read it in the same flow.
At least we should change the output format to .yxdb, which is very good data format.

There is another issue I can observe is that you are trying to write the data to the two sheets of one Excel.

In such case, we use the Tool of Block Until Done.

LPR - Revenue Visibility Workflow-r1.yxmd

bustamantebrenda187

Good morning, I am trying to figure out what might be causing this error on my workflow.

Output Data (97) Can't open file: \\ad101.siemens-energy.net\dfs\EnergyFS\NAM\CLTW-ACCT\FIN DIGI\3. Alteryx workflows\CAPEX\LGN_FY25_CONSOLIDATED.xlsx: The process cannot access the file because it is being used by another process. (32)

I get the same error in two parts of my workflow. in control containers 254 and 255. Is anybody willing to take a look and help me figure out what the issue might be in this case? I appreciate any help!

FY25_LGN-CAPEX_Consolidation.yxmd

peyton-brooks

Hi - did you by chance find resolution on this? I am experiencing the same issue inconsistently in some of my monthly workflows and we are also utilizing control containers to sequence the writing appropriately to prevent this error... Haven't been able to solve the issue for months!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703