Partner Zone

MYOB 2022.11.0 Build 2022.11.24.7649 Export to excel not working

DeJong
2 Posts
User

2Posts

1Kudos

0Solutions

MYOB 2022.11.0 Build 2022.11.24.7649 Export to excel not working

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. 

 

 

2 REPLIES 2
Komal_S
MYOB Moderator
8,280 Posts
MYOB Moderator
MYOB Moderator

8,280Posts

726Kudos

1,161Solutions

Re: MYOB 2022.11.0 Build 2022.11.24.7649 Export to excel not working

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-...

Kind regards,
Komal

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

DeJong
2 Posts
User

2Posts

1Kudos

0Solutions

Re: MYOB 2022.11.0 Build 2022.11.24.7649 Export to excel not working

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

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post