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.
Have you installed ‘Analysis ToolPak’ Excel Add-in for the 800xA Service account? This Add-in is for "Interactive Use" only. Since the Scheduler runs Excel in the background as the 800xA Service account, when the scheduler tries to open this Addin while opening excel, the Excel API "Workbooks.Open" will fail.
The discussed Excel add-in must be disabled for the 800xA Service account for the scheduler to open the workbook in the background.
Is you still need this feature in Excel for the 800xA service account user on the IM, the "Analysis ToolPak - VBA" Add-in should be used instead.