Excel error

[ḥari]

Hi team,
I am facing error while fetching datas from excel in execution time alternatively (one time it's executing and another time it throws error as "excel internal error element not found" And " The access to the excel file is blocked. Possible because it is open in excel"

But no excel file is opened in my machine i have restarted, cleared temp files and task manager as well.

I tried to watch that excel variable in "add watch" While getting that error excel variable is returning as "NULL"

The same script are executing fine in other machines only in my machine i am getting error alternatively.

I have attached the error log report below for your reference

Can any one give me a solution for this??

It's a great help for me!

Many Thanks!

[rraghvani]

Are you able to provided the exact coding and spreadsheet, so that we can try and reproduce it?

Have you tried repairing your installation of Office/Excel?

[ḥari]

@rraghvani i didn't tried to repair of excel/office in my machine

[rraghvani]

You say that the scripts work fine on another machine, accept for yours .Which usually indicates there's some sort of issue with your machine, which could be relating to Office/Excel.

[ḥari]

Yeah @rraghvani that what I am also thinking but i don't have any access to do in my machine, today I requested to check those things. After they completed repair I will check it and let you know

[rraghvani]

Also ensure you have sufficient access to files and folders, as this can cause an impact too. I don't know where you are reading your Excel file from.

[ḥari]

I have access to those files and folders, I am fetching those excel files from user profile "environment variable"

[ḥari]

@rraghvani i did repair of excel/office application in my workstation. Still I am getting same error in test complete

[rraghvani]

What do you mean by I am fetching those excel files from user profile "environment variable"?

[ḥari]

@rraghvani excel file are accessed from user profile (In run -> ℅userprofile%-> enter)