Unable to export reports to Excel

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
RosalieC
1 Post
User

1Posts

0Kudos

0Solutions

Solved: Go to Solution

Unable to export reports to Excel

I have been unable to export reports to Excel. 

Diagnostic report is attached.  

1 REPLY 1
Komal_S
MYOB Moderator
8,280 Posts
MYOB Moderator
MYOB Moderator

8,280Posts

741Kudos

1,164Solutions

Accepted Solution Solved

Re: Unable to export reports to Excel

Hi @RosalieC 

 

The error log mentions this specific error, " System.InvalidCastException: Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass

 

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. A 
range of these errors can be fixed by one of the following:

 
1. Quick Repair office. (any missing files should be added back)

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

 

Feel free to post should you have any other queries.

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

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