Write Range Workbook Process in Use

Help Activities
1

I have a workflow that does several changes to an Excel spreadsheet. The last thing I want to do is to take a filtered data table that removes specific values and write it back to the spreadsheet. The problem is that when I do that, the Write Range Workbook gives an error that the file is already in use. Ok. So I added a new Excel Process Scope after that one and reopened the file and try again. Same error. I added a 30 second delay between scopes. Same error. I added a Kill Process->EXCEL and then a 30 second delay. Same error. Seems pretty straightforward. Any thoughts?

2

Hi,

If possible, can you share your current workflow?

Regards,

3

Hi @rschoech ,

If you are already using excel process scope then enable save changes of the use excel file container,

Try using the modern activity,

Instead of write range workbook.

Hope this helps you resolve.

Thanks,
Gautham.

4

So this was a newbie error where I did not realize that the activity I was using doesn’t actually require the Excel process scope and was creating the problem. Once I took it out of the scope it created the spreadsheet just fine. I will definitely start using the Write DataTable to Excel activity in the future though. Thank you for the assist!

5

That’s okay…! We are learning together , its good to learn from our mis steps:-)

@rschoech , if you have found the solution kindly mark the response that helped you as solution or post the steps you took to implement the solution mark that itself as solution to close the thread.

Happy automating.!