Excel Not Loading

Help Studio
,
1

Hi,

I am experiencing a problem where Excel is not loading properly in a live environment. The bot is able to open the required file, but excel just presents an empty screen (see below).

image
image1454×741 20.3 KB

When running the bot in the dev environment it opens fine. Below is the excel activities properties.

image

image

There is a custom Add In in the file, but this add in is used in other processes and this issue is not happening there.

Thanks

2

Hello @b.forbes - Does the same issue happen when the file is opened manually in the live environment?

3

Hi, no the document opens fine manually in the live environment and the dev environment.

4

Ive had some wierd stuff going on with excel recently, just check if you have a background excel process running, when the App is actually closed. If you do kill it and try again

5

Yeah, there is a kill excel activity outside of the workflow that uses this file and the excel process scope is always create new

6

@b.forbes

Try with show excel window as not visisble …automation as the launch method…and macro settings disabled and display alerts false

Also may I know what actions are you performing on excel?

Cheers

7

I will try that. I am using the file to upload data to an application via the Infor QnA add in.

8

@b.forbes

then may be the addins are not loading please check the setting son your dev machine and use the same …I mean the excel settings

mostly it would be the activex and trust center settings that you need to check

cheers

9

I have changed all the Trust Centre settings to not interfere with the Excel document, and enabled all macros etc. What’s odd is when I sign into the prod environment and run the bot via the assistant it works perfectly, but when the client does it from their end it breaks. Which makes no sense.