Answer question
Report Error automation object for type EX: Open method of workbooks class failed
Request your support on the report issue.
When we generating the report with “Scheduler Group_IM” we are getting this error “error subscribing to automation object for type Ex: open method of workbooks class failed”.
And When we are generating the report with “Scheduler group Aspect Server” we are getting “Invalid Report”.
In MS Excel 2016 has both Data direct addins.
I have Attached the Screenshots as below and the logs.
We tried to repair the Excel.
We also noticed that scheduler function was not deployed to the Im server, and later we deployed to IM server and tried the report scheduling, but faced the same issue.