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