MYOB 2022.11.0 Build 2022.11.24.7649 Export to excel not working

[DeJong]

Hi all, I have encountered this problem at my new work place where I am trying to export the report into excel format and it does not work. It does not come up with an error either. Simply nothing happens after I click on Export-> Excel. Rest of the export features are working like export to pdf etc. Can somebody please provide a solution for it?

I have also attached the Diagonostic Log as it has been repeatedly asked by the MYOB experts in similar situations. 

[Komal_S]

Hi @DeJong 

The log that you've attached mentions this specific error "System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass" which is an interop error meaning when a program such as AccountRight asks which version of Office/Excel is installed, the wrong version is being reported back, causing a communication problem and errors between the programs.

This can happen when different versions of Office/Excel may have been previously installed on the computer, and components/values are left behind.

There is a range of interop errors, these most often are fixed by one of the following:

A. Quick Repair office. (any missing files should be added back)
B. Re-Register DLL files and Check/Fix Registry Keys (there are 3 to complete)

Step B would require an IT Professional as its an environmental issue, with windows having missing or incorrect information and this help article has similar instructions which might help: 

https://webmakers.co.nz/interface-not-registered-exception-from-hresult-0x80040155-microsoft-office-...

[DeJong]

Thanks Komal. I will let our IT guy had a look into your solution and will report back whether it worked or not.