Export to Excel not working

Question

Hi,&nbsp;Since the latest upgarde to version 20232.1.24.7870, When exporting reports to Excel, nothing happensI looked up the log and this is the report:&nbsp;2023-03-13 12:12:12.9505,MYOB.Huxley.RF.Core.Services.AppService.RFLogService,Error,1, : 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: Interface not registered (Exception from HRESULT: 0x80040155).at System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr&amp; ppTarget, Boolean&amp; pfNeedsRelease)at Microsoft.Office.Interop.Excel.ApplicationClass.get_Workbooks()at MYOB.Huxley.RF.Extension.Export.Excel.Formatter.CreateXls(String fileName)&nbsp;This is too technical for me.Any suggestion to resolve this issue?Thank you

melisa_d · Answer

Hi&nbsp;Topbuild,&nbsp;
&nbsp;
It looks like you're experiencing the&nbsp;Microsoft.Office.Interop.Excel._Application&nbsp;error.&nbsp;Generally this error means that when a program such as AccountRight asks which version of Excel is installed, the wrong version is being reported back, causing a communication problem and errors between the programs.
&nbsp;
This can happen when different versions of Office/Excel may have been previously installed on the computer, and components/values are left behind. This type of error can be fixed by one one of the following:

Quick repair office.&nbsp;(any missing files should be added back)
Check/Fix&nbsp;Registry Keys (this step can only be completed by an IT professional as this is an environmental issue with windows having missing or incorrect information). Reference link as an example for Outlook is :https://webmakers.co.nz/interface-not-registered-exception-from-hresult-0x80040155-microsoft-office-...

Please do let us know how you go.&nbsp;
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Forum Discussion

Export to Excel not working

1 Reply

Looking for something else?

Related content

Exporting GL transactions details report to excel not working

Excel formula not working when exported

Can't export reports to Excel

Unable to Export Reports to Excel

AccountRight not exporting to Excel

Export to Excel and send Excel file not working

Export to Excel not working in AccountRight 2021.8

Export Reports to Excel