In using two excel files for my automation, it will get to a point where I’ll try to open the excel file to indicate which cell and the file wont open. Instead is kickback an error message that “… open in another application”. This is despite ensuring Excel is not open, the file is on my local drive, and I’ve cleared my Task Manager.
Further, after closing UiPath studio to open the file first, the same error appears.
I keep encountering this problem unless I restart my computer.
Hello @laurabjackson
Looking at the scenario and popup, following are the chances:
Check if the file is open on another device**: Sometimes, the file might be open on a different device, or the previous instance of the file didn’t close properly.
Check if the file is being synced with OneDrive: If the file is saved to a OneDrive folder on your PC, the OneDrive app might be preventing Excel from opening the file.
3.Check for add-ins causing the lock: Inactivate any Excel add-ins that might be causing the file to be locked.
Check if the file is locked by another process: The file might be used by another process, which could be causing the error. You can check this in the Task Manager.
Also looking at the path in popup - ‘https****’ - I assume if the file contains any external links or the format if I am right is ‘https://******.xlsx’ which won’t be supported by Excel Application Scope. The path is trying to open a remote file.
If you can attach the Studio Debug trace for review as screenshot if possible, or try to manually open the file.
