Error: The process cannot be access the file because it is being used by another process.

[Shakil1]

Hello Users,

I'm getting this error when trying to get the data into Output for multiple excel sheet tabs.

Request you to please advise asap.  Thanks!

[Bren_Spill]

Hi @Shakil1 - you have the block until done tools in the wrong place. They should be placed at the point the data stream splits. Putting it right before the output tool won't work. See screen shot for a basic example of correct and incorrect set up

 

[Shakil1]

Hi @Bren_Spill, 

Thank you for looking into this!

I had already tried adding the Block until Done tool in begging and also in the end of the Output, but that still not working.

I'm trying to figgier out this from last 2 days but no luck yet on this.

My requirement are: In one excel file, I have 12 sheet tabs are connected with Output tool to get the data in each sheet tab.

Please help to fix this. I appreciate your help.   Thanks! 

[Bren_Spill]

Can you provide a sample of the data that you are writing out? You may be able to use the Take File/Table Name From Field functionality in the output tool

[Shakil1]

Hello @Bren_Spill,

I know this functionality  "File/Table Name From Field functionality in the output tool" but this will not work because I do not have the data in single file.

I'm trying to take required column from different section in each sheet tabs in Excel file.

[Bren_Spill]

@Shakil1 Can you provide a sample of the data?

[Shakil1]

Hello @Bren_Spill,

There is a big data, and I cannot provide sample data. I'm trying to take out the unique value from each Join in single Excel file but in different sheets.

There are 12 sheets in the Excel file only 2 sheets get updated and all other 10 sheets show the error message as "The process cannot be access the file because it is being used by another process"

For you reference I have attached the workflow screenshot to take a look.  Please help me to fix this asap.   Thanks!

[Raj]

@Shakil1 
you need to use multiple block until done tools to achieve this.
if you can share a small part of workflow with sample data then will be able to correct the mistakes.

[Bren_Spill · Accepted solution]

@Shakil1 - The parallel block until done tool would be useful here. If you can send a sample workflow we can test it, or try setting it up like the screen shot below. You can download the tool here: http://downloads.chaosreignswithin.com/Macros.zip

[Shakil1 · Accepted solution]

Hi @Bren_Spill  and @Raj 

Thank you so much for looking into it!

Workflow has been fixed now. It's working as needed. 

I had just deselected the AMP Engine option and I used block until done tool as show in my previous error screenshot. It Run successfully without any error message. 

I appreciate your help!