Excel Sign In PopUp Issue

News Knowledge Base
1

Robot stuck while reading Excel file due to pop-up from Excel application.

Investigation: Robot generally does not show any pop-up during execution. Hence first step in such type of issue would be to,

  1. See what information that pop-up is showing
  2. Check the behavior of excel by manually opening it see if similar pop-up are displaying
  3. In some scenarios it might be Excel license related, Excel add-in or any hyper link URL references causing such pop-up.
1N.jpg


Root Cause: This issue occurs because the Excel sheet has so many references and links provided in the Excel.


Resolution:
  • Remove such pop-up by removing such references of cells and links in the Excel spreadsheet that is tried to open and perform the automation in that sheet.
    2

    When this happens, the robot hangs and never finishes. It seems to not realize that the popup is there, and never times out. Even when there’s a max time limit set in Orchestrator, it doesn’t get terminated.

    Does anyone else have this problem?