UiPath - Intermittent Failure with Execute Macro - Not able to replicate manually

I have a simple process that runs a query to return data and then uses an excel macro to format and save the report.

When scheduling the process to run on an unattended bot, it fails during the macro activity about 50% of the time. If it fails, I can immediately run the process again, and it will often be successful. The macro does not have any errors when ran manually from within excel, validated 20+ times.

Any ideas on where to start troubleshooting this? I can’t get an error message from excel through UiPath, so I’m not sure what is even failing.

Any help is appreciated. Thanks!