Hi! I am trying to run an automation with several Excel sheets, but the sheets are in Read Only mode. I have tried turning it off with Properties in the File Explorer, but I am still getting the same Read Only mode error. What should I try next? I am not the developer, just the Business Analyst.
Hi @kadams11
check if they are open by someone else, stored on a restricted network drive, or have protection settings; also, ensure Excel is fully closed in the background.
Or
ask the developer to disable the ReadOnly option in the Excel Application Scope or try using local copies of the files.
If helpful, mark as solution tick. Happy automation with UiPath
Hi @kadams11
Firstly check if you are able to do any edit operation in those sheets manually?
If yes, then issue might be any of the below
-
bot doesn’t have full permissions on the file/folder
-
file is in use by another application/user at the same time when bot is trying to interact as well. Also confirm if file is in local or shared drive?
-
excel scope has read only property checked
-
file itself is read only. Right click and check properties
Please close all excel instances before running UiPath workflow. Use kill process activity to kill any opened excels.
1 Like
Try Below points,
- Open Files and disable the read only mode and save the file Manaully. then try with Automation
- Look for your activities propertied whether you enabled read only property, if yes disable it and try.
- If you both set properly and still not working properly, Try to takeout the files from shared drive/OneDrive if files are placed there.
Happy Automation!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.