I was upgrading LabVIEW 7.1 code to LabVIEW 2020 (32 bit) which has activeX excel report generation. Code upgraded for Win 10 OS 64 bit & Office 365 - 64 bitVersion. While executing the EXE in some other Win 10 OS with Office 365 version machine got Excel Error "-2147319784".
To solve this issue ActiveX function used VI properties->Execution->Preferred Execution System changed to User Interface based on the https://forums.ni.com/t5/LabVIEW/What-is-error-2147417851/td-p/103921 forum suggestion.
EXE crashes while generating Excel report in Win10-64 bit OS with Office 2016-64 bit machine.
To solve this issue, we removed the “Save As” ActiveX function in code & replaced with Save function. After that it works in both Office 365 & 2016 (both 64 bit) with LabVIEW 2020 32 bit
Here development machine Office 365 version also important we used Version 1609
Hope this will help...
