Anyone has experience with this error “Excel appears to be busy. Please check that you are not editing a value and that no dialog windows are opened.” After clicking Retry in Debug mode, the problem is solved. This error comes out frequently and inconsistently. Any help would be appreciated. Thanks!
Please find the useful link.
This error does not pop up anymore after adding a kill process activity before opening the excel application scope. However, now i am experiencing a new issue which is editing a shared excel file. Sometimes it works sometimes it throws an Exception from HRESULT: 0x800AC472. I have to edit the shared file instead of cloning it into a local file because multiple robots will be updating the excel file at the same time. May i know how do i solve this shared excel file editing issue? FYI, adding kill process before the excel application does not work.
Your links don’t seem to be of any help to the difficulties I faced. Thanks for trying though.