BOTs fail while using shared excel if some other user accessing the same file.

Question

BOT fails while using shared excel if some other user accessing the same file.

I have automated one excel related work, Have use one excel spreadsheet as an input file form that file BOT will take all data one by one, But BOT stop working when some other user accessing that same file.

We can't move that file to VDI, because along with BOT human also working on that same file to process Business exception accounts….

So, we are not able to move that file to VDI, as a results if someone accessing that file to complete Business exception scenarios that time BOT stop working.

and if we remove the shared option form excel file then no one able to access that file to complete Business exception scenarios and due to high counts, we are not able to stop the BOT for any other person to complete business exception scenarios….

So, is there any other way to resolve this issue?

Page 1 / 1

Hi @Bapi 81

In the above case as the same file is accessing by multiple user's bot can’t work on it parallelly. In this case take a copy of the excel file into local machine, work on it and once bot run completed overwrite the local file into SharePoint.

Reply

Narendra 5601 · Answer

Hi @Bapi 81In the above case as the same file is accessing by multiple user's bot can’t work on it parallelly. In this case take a copy of the excel file into local machine, work on it and once bot run completed overwrite the local file into SharePoint.

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded