Anhijit,
Honestly, I think most of your problems will come from the Excel functionality and not the Bue Prism VBO. That is, from experience, having an MS Excell workbook that allowed multiple users access at the same time was challenging. If one user saved their changes, changes actively being made by other uses were often not saved. We also had issues where there would be 'phantom' instances of users remaining attached to the document long after they closed out of the file. Currently, we use a Sharepoint version of a status log, which more or less mimics this funtion, but I still kind the need to check the workbook out a bit clunky.
As is mentioned by others, I think your best option is to use one or more workqueues to accomplish your stated goal.
1. Move the Excel data to a workqueue
a. Bring the Excel document into one or more collections
a1. If the current presentation order is important, then I would add index fields/columns, as necessary
b. Move the collection into a workqueue
2. One or more of your Bots/Resources can process the work queue
3. Save the updated workqueue information to the same or a new Excel workbook
a. Bring your workqueue back into a collection
b. Save your collection to Excel
b1. I often will save the updated information to a new worksheet ('raw data' versus 'output') which allows for relatively easy audits by the Business.
Good luck,
Red
------------------------------
Robert "Red" Stephens
Application Developer, RPA
Sutter Health
Sacramento, CA
------------------------------
Robert "Red" Stephens
Application Developer, RPA
Sutter Health
Sacramento, CA