800xA 5.1 RevC Excel 2013 Report Error automation object for type EX: Open method of workbooks class failed
We have an 800xA 5.1 RevC system (windows server 2008 R2 & Microsoft office 2013) and now face a problem generating reports.
Daily excel reports and scheduled jobs were successfully created. But after a few succesful runs( 6 to be exact) the scheduled jobs started failing suddenly with the error message "Error subscribing to automation object for type EX: Open method of workbooks class failed"
Excel 2013 still has no error messages when opened individually and BDM and datadirect still work fine. Able to generate reports using datadirect buttons on Excel window. but 800xA jobs fail, whether scheduled, or using the "run now" option.
any help towards solving this problem and getting the excel reports to be generated again would be much appreciated. Many Thanks!
These files are cached data files for any control added to a Microsoft component (like forms in Excel). When you are using Add-Ins(like DataDirect), you are inserting some ActiveX controls to the excel.