I have Master excel in share drive all the 10 robots/bots should update the data in same master excel .
I have tried updating date to Master excel in same time but it is throwing an error like “Excel file was locked by other user’s”
Error:
System Exception : Retry: 0. Microsoft Excel cannot access the file ‘\spgrantfile01.cotyww.com\DEPART\Controlling Exo\000 New EXO\00.ReminCo\Costing\RPA PIR OVH Freight automation\Q05\Execution Log.xlsx’. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook. at Source: Invoke Update_Execution_Log workflow: Excel Application Scope
Is any other ways to update the master excel in same time.
Hi ,
you can create a Queue item for the Master Excel file .
A bot can fetch the queue item and then update it and postpone it so that the next bot can fetch it .
This can help you to avoid the issue you are facing now
You can create a queue item in a different queue for Master Excel so that only one bot will be able to access it at one time.
Or you can surround the Master Excel update activity in the retry scope and give adequate retries . so bot can retry the set of activities during the error.
can you let us know what is the error? if you are using queues , then you would need to update your workflow to wait for the queue item to be available in the bot.