I have a scenario where the bot can edit excel when it is open by a user for editing. The bot and user can only update different columns. I tried adding excel scope>write range> if the excel is open the bot cant access it. is there a workaround for this?

hi yes it is back end automation. I figured out a way to use onedrive and the sync the office 365 excel from there. Thanks.

How do we allow a bot and a user to concurrently edit excel file?

ANSHUL (MANTRI) August 28, 2019, 1:22am 13

no relationship between the columns, they can be edited in Office 356 by 2 different users at a given time.

1 Like

Multiple robot manage same excel report file

Excel operations in orchestrator

Topic		Replies	Views
Same excel file use by multiple bot Activities datatable , excel , selector , uiautomation , pdf , mail , orchestrator , robot , activities , studio , data_scraping , string , studiox , question , activities_panel	3	2855	April 13, 2022
Problem in writing to excel file which is open on another system Activities excel , activities , question	4	1600	July 1, 2022
Input file shared with business Studio	8	875	March 14, 2022
OneDrive sync issues whenever a bot changes an excel file Activities excel , activities , question , sharepoint , onedrive	0	429	June 1, 2023
Multiple robots updating the same shared excel file Help datatable , excel , studio	10	5190	January 6, 2021