Select Page
Welcome to our Knowledge Base

Dialogue script not loading

You are here:
< All Topics

Applies to

Dialogue Elite software


Unable to load a calibration script or system suitability script. Exporting chromatogram data to Excel not working.


Possible causes:

  1. Excel not correctly installed
  2. Wrong version of Excel installed
  3. Conflicting programs on PC
  4. Registry error due to MS Office install history

Diagnosis and Remedy

Switch on the log functionality in Dialogue Elite: Go to the ‘log’ tab and check the log functionality at the left bottom of the screen. Repeat the situation and when the error occurs go to the log tab, click ‘err’ at the left bottom. See if any errors are visible that relate to Excel.

A known issue occurs when the installation of Office has been removed and reinstalled with another version (i.e. a 32 bit version was replaced by a 64 bits version, or Office 365 replaced by Office 2023). The root cause is that some registry settings are not cleared when the PC was not restarted in between versions. Result is an ‘error loading type library/DLL’. In that case, the problem can be fixed by running a ‘repair’ on the Office installation, and restarting the PC. See this Microsoft KB thread.

Error message in log file:

System.InvalidCastException: Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
at Microsoft.Office.Interop.Excel.ApplicationClass.set_DisplayAlerts(Boolean RHS)
at Dialogue_Elite.common.ExportDataExcel(String fn, String Tag)

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
How Can We Improve This Article?
Table of Contents