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!
Insert the URL that your highlighted text will link to.
Copy the video's "embed" tag into Embedded Video below.