Excel used by another process cannot access error

supu123 · June 30, 2021, 3:35am

Hi Team,

I m reading the excel from share drive but the error is displayed
Tried with both excel scope activity and workbook range but the issue is the same

How to handle this error

Thanks and Regards,
Supriya Galentic

PRASHANT_GABHANE · June 30, 2021, 3:54am

[quote="supu123, post:1, topic:326248

Try Kill Process (excel) before accessing.
It might work

supu123 · June 30, 2021, 3:56am

Thankyou for the response

kill process is also not working
I think because the file is on share drive and is used by another user

Thanks and Regards,
Supriya Galentic

PRASHANT_GABHANE · June 30, 2021, 3:58am

Yes,

Microsoft 365 activities might help then.

supu123 · June 30, 2021, 4:00am

How does this work can I get any sample

Thanks and Regards,
Supriya Galentic

PRASHANT_GABHANE · June 30, 2021, 4:03am

Using Graph API we can also achieve but i never implemented in my code.

lojyehuang · June 30, 2021, 5:56am

@supu123
Try Copy File Activitiy before accessing.
Then, you can use that new excel.

Topic		Replies	Views
Not able to read data from excel_getting error "The process cannot access the file because it is being used by another process" Help excel , activities , error	7	1753	November 16, 2019
Error reading excel from onedrive folder Help excel , activities , error , microsoft_office365	7	2612	January 7, 2020
The process cannot access the file 'PATH' because it is being used by another process Academy Feedback excel , uiautomation , activities , studio	5	7565	March 9, 2018
Excel process used by another process Activities excel , activities , question	9	236	January 17, 2024
MS Excel. Overview. Cannot access the file because it is being used by another process Help excel , activities , question	6	4423	September 14, 2020