I’m getting this error when opening an excel file in my process. There are a couple of other similar topics but none of the solutions have worked for me. This is the first time the particular excel workbook is opened in this process (using excel application scope).
Earlier in the process, two separate workbooks are opened and their data is collected into a datatable using read range. Both files are closed by the time it comes to open my desitination file. Excel package is up to date.
Hi
Welcome back to uipath community
Kindly try with WORKBOOK ACTIVITIES with READ RANGE ACTIVITY instead of EXCEL APPLICATION SCOPE and try once
That would work for sure
Cheers @dgreen
I have faced this issue some times as well. My observation is this error happens when there are more than one excel application (or processes) running in the background. If there are no other excel books open while opening this excel sheet, before the Excel Application Scope activity, use a Kill Process activity to kill excel.exe processes.
Thank you this helped reduce the occurence of the error. It still occurs sometimes when excel is running in the background - i think this is due to me saving to a drive and the time it takes ti sync the file. See me response below to learn more about kill process for excel.