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

[jperles]

I have an Analytic App that performs different calculations from inputs and places them in different cells within the same Excel spreadsheet. To do this, I created multiple outputs using the Overwrite Sheet or Range option. To avoid the error "The process cannot access the file because it is being used by another process," I tried setting "block until done" to each recalculation (as seen in the image), but I still get the error. Can anyone tell me how to fix this?

[cjaneczko · Accepted solution]

Have you tried to use Control Containers for the outputs? Try placing each output into a separate control container, then link each control container in the order you want them to write.

One other thing to check is if the file location you are saving to is backed up by one drive. After the first file is saved, One Drive will start to back that file up. While its backing up, Alteryx cant write to the file as its in use. A work around for this is to pause your One Drive backup when you run the workflow. 

[alexnajm]

Agreed with @cjaneczko - control containers is the way to go if you are on 2023.1 or newer: Control Containers: Take Control of Your Workflow - Alteryx Community