SIR Macro Error - Automation Error Catastrophic Failure

SOLVED

Hi All

I am experiencing an issue when running reports with Macros.

The first report with a macro runs successfully but any subsequent report with a macro gives us the Automation Error - Catastrophic Failure.

We have tested the following:

1. Running the reports with the same Macro. First runs successfully, second raises error

2. Running this with other macros. First runs fine, second raised error.

3. We utilised both 32 bit and 64 Bit and the same errors occurred

4. We ran the same reports on an earlier version of Excel and this works without any errors

These issues have only been  experienced since the last Office Update which occurred circa 2019-06-01