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,
- See what information that pop-up is showing
- Check the behavior of excel by manually opening it see if similar pop-up are displaying
- In some scenarios it might be Excel license related, Excel add-in or any hyper link URL references causing such pop-up.
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.