Excel locking issue

HI Team,

While trying to open an excel file getting following pop-up “excel is already open, Reopening will cause any changes you made to be discarded. Do you want to reopen


But same thing was not happening when opening manually

Note - Excel is not opened by any other robots/users .

@loginerror @ovi
Kindly provide your thoughts on this

Best Regards,
Naveen Chagnati

@Naveen.Ch

Can you share excel file which causing issue?

Thanks

1 Like

@Krishna_C

Thank you the response.

I cant able to share the excel file due to confidential data.

Example we have robot5,robot6 and robot7, It was working fine in robot5 and robot6 but it is not working in robot7.

In robot 7 we are getting this pop-up every time.

Best Regards,
Naveen

@Naveen.Ch

Are they using the same sheet parallely? You can put a kill process after end of your workflow

Also make sure that the same version of excel is installed across

Hope this helps

Thanks

Hi @ksrinu070184

Excel has been installed in all the robot accounts.
But we are getting above issue in one robot only.

Best Regards,
Naveen

Thus, there are no other excel processes running on the machine? Could you double check in the Task Manager?

1 Like

hi @loginerror

Yes, we have checked nothing was running related to excel.

Best Regards,
Naveen

@Naveen.Ch

  1. What type of robot installed on your machine :- User Mode/Service Mode
  2. Are you using VM or VDI ?
  3. XLSM file that you are working on is in local drive or shared drive ?
  4. Can you do a for loop just before opening this excel file and print a list of processes running at the backend for this you can use GetProcesses and print names in notepad to output pane.

Above steps will help finding root cause of it.