Excel Loop Issue

If you are getting the below error during Setup Environment or Test Run:


 

You need to disable application Add-ins from excel. To remove Add-ins from excel, you need to perform the below steps:

  1. Go to Excel options and select the Add-ins tab.
  2. Under Active Application Add-ins, you need to remove additional Add-ins (E.g.: WebEx Integration Add-ins).

For example, If the user doesn’t have access to remove Add-ins, you need to change the Save Option to EndOfLoop under the Loop Properties in the properties tab of the Excel Loop activity in Automation studio so that automation is not impacted.