Workflow unable to communicate with excel after upgrading to office 365

[yjkim (Kim Yu Jo)]

Hi there,

I have just upgraded my Microsoft office to office 365.

I have a workflow that works perfectly fine previously, however after the upgrade, it always gets “stuck” before performing an Excel Application Scope activity.

For example, I programmed it to open the excel sheet called “FullList.xlsm” using excel application scope.
When debuging, i realise it stops at this execution and hangs.

When i tried to manually open the excel sheet, it tells me it is locked for editing, which i assume is due to UiPath Studio.

Any ideas how do i resolve this?

Thanks!

[jibanjyoti (Jiban Jyoti Rana)]

Send screenshot of your excel application scope and what is the current extension of your excel file?

[yjkim (Kim Yu Jo)]

Hi jiban,

Attached screenshot of the workflow with the excel application scope.

The excels that im working with are all .xlsm as I have some macros in them for UiPath to execute.

Thnks!

[jibanjyoti (Jiban Jyoti Rana)]

No Idea, May be because of the .xlsm file it is freezing.
Can you try the workbook related activity: Write Range, It accepts the file path also directly. You dont have to use excel application scope.
@badita, can you please help here?
Thanks,
Jiban

[slistrom (Stephen L)]

Any update on your issue?

[Gabriel_Tatu]

Can you give more details?

[JobinJoy.jnj (Jobin Joy)]

Let go through this…
I think the problem is with Microsoft Excel.

[JobinJoy.jnj (Jobin Joy)]

Try this also.