Excel sharing with multiple bots


Currently I am using Share drive to keep test data and Result file. But I am getting excel lock error when 2 bots are trying to update same excel sheet.

Whats best way to handle this issue?

Currently i am keeping excel in Shared mode to fix this problem, any other optimized solution?

If u r using parallel or multiple robots, then add the file reference to queue first. Then get transaction items .

But how that’s gonna solve parallel write problem ?

Its better to Copy a Local Reference and then move to the Sharepath.