Excel stuck during autosave infinitely after UiPath runs macro

Hi there,

I am working with 2 excel workbooks, which UiPath will execute the macros written.

Macro1 will be executed in Wrkbk1.

Filtered Data will automatically be transfered to Wrkbk2 from Wrkbk1.
.
However, when closing Wrkbk1, both Wrkbk1 and Wrkbk2 will be stuck in infinitely while attempting to autosave the Wrkbooks.

This has either cause my Robot to run infinitely, or it will result in the error below.

Any idea how to overcome this?
THanks!
Kim

Below screenshots:

Capture

image