Report fails to export to excel

Question

Does anyone know why the trial balance has all of a sudden fialed to export to excel?  No upgrades to either escel or AR 2022.3.  Was working fine yesterday then has stopped beng able to export.  Can still export to PDF by excel nothing happens.

Scott

Melisa_D · Answer

Hi @Scott_Generus,

Thanks for the error log. Looking at the error log I can see that you're experiencing the Microsoft.Office.Interop.Excel._Application  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.

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. (any missing files should be added back)
* Check/Fix 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.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Scott_Generus · Answer

Hi Melissa

No error messages come up when (attempting to) export to excel.

Attached is the diagnostic file after I’ve attempted to export a trial balance out of the Generus MYOB file to excel (still unsuccessfully)

Huxley.Application_2022.3.24.6313.log

Melisa_D · Answer

Hi @Scott_Generus,

Thanks for your post. Do you get any error messages when you attempt to export to excel ? If not, are you able to retrieve the diagnostic log of the AccountRight file after you've attempted to export to excel and attach it as a .TXT file to this thread so I can investigate.