Hi All,
I have an excel file which is placed on shared location and bot needs to keep it updating, but bot fails to do so if it is open by someone else on their system. I have tried using workbook activity but no luck. Please help!
Could you try changing to the below Steps :
- Move the File from the Shared location to the Bot folder.
- Update the file.
- Copy the file back to the Shared location.
Check if the above method works, It shouldn’t give out an error for the 1st Step, but the last step it will give out the error if the file is open.
Or You could try using Excel Application Scope
Activity with Property Visible
enabled.
Let us know your thoughts on this.
There’s nothing that can be done about this. You’ll have to make sure people aren’t opening the file. This isn’t a UiPath thing, this is Excel. An Excel file can’t be opened for editing by two people nor processes at the same time.
Step 1: Click the Review tab. Click Share Workbook in the Changes group. On the Editing tab, click to select the Allow changes by more than one user at the same time.
Step 2: Use Excel application scope and ExcelAppendRange Activities to append the items in the same excel.
It will work perfectly in case the BOT and the human are updating in a different sheet on the same excel.
Watch out: It may have some issues if both are trying to update the same sheet on the excel file.
As a best practice, have a separate sheet for BOT-related updates.
Hi @supermanPunch, does your workflow resolves the problem with excel files that are always in recovery mode when downloaded from the shared location?
I have a similar problem - more people are using the same excel file which is located on SharePoint.
When the robot downloads that file, sometimes it goes into recovery mode which prevents the execution.
What is worse - I am not able to use any activity that could close the error message within excel.
My manual solution is: I download the file that turned out to be in recovery mode on my PC, open it, save and then upload it again on Sharepoint. In this case, the robot is able to proceed with the execution.