Unable to remove old backup when using Control Containers to sequence the outputs

[goosekong]

I'm going to write about 400 different ranges in one Excel template because I need to populate the data in the white cells but skip the blue cells and grey cells (example as below).

So I'm using control containers to sequence the outputs to write the values in different ranges in one tab. But there are about 400 control containers and outputs. It comes a problem that it encounters a few errors "Unable to remove old backup file name.xlsx.bak: The process cannot access the file because it is being used by another process. (32)". And if I run the workflow again, the errors won't be occurred in the same outputs as last time and occurred in other outputs. 

May I know how to solve this problem?

[Gaurav_Dhama_]

.bak file is a backup of the excel file that just got modified, so if you write to an excel say 5 times in one workflow, it will generate that .bak file 5 times.

Now coming to the error you are facing, that is happening because windows is trying to generate this .bak file while the previous one is still in use. See if the sequence is correctly sequenced.

Also check if there is any backup running, like one drive backup.

[goosekong · Accepted solution]

I found the similar case Solved: Wait a sec macro or similar solution - Alteryx Community with this post. 

By using the macro the workflow can be run successfully without errors.