Forum Discussion

tomwidauer's avatar
tomwidauer
3 years ago

Export to Excel not working in AccountRight 2021.8

I have a customer who is experiencing issues with exporting reports to Excel.    This has worked in the past but apparently isn't now. They haven't done this in a while, so we cannot tell for sure ...
  • Melisa_D's avatar
    Melisa_D
    3 years ago

    Hi tomwidauer, 

     

    Thanks for your post and welcome to the Community Forum ! Can you please retrieve the diagnostic log of the AccountRight file after attempting to export to excel, if you open the error log can you see a Microsoft.Office.Interop.Excel._Application error ? If you can, 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:

    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.

Melisa_D's avatar
Melisa_D
Former Staff

Hi tomwidauer, 

 

Thanks for your post and welcome to the Community Forum ! Can you please retrieve the diagnostic log of the AccountRight file after attempting to export to excel, if you open the error log can you see a Microsoft.Office.Interop.Excel._Application error ? If you can, 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:

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.

tomwidauer's avatar
tomwidauer
3 years ago

Thanks Melisa, this was very helpful. I did indeed see the Microsoft.Office.Interop.Excel error and was able to get it to work following the Link you had provided.

 

Cheers

  • Melisa_D's avatar
    Melisa_D
    Former Staff
    3 years ago

    Hi tomwidauer, 

     

    You're welcome, I'm glad that has resolved this for you. 

     

    Feel free to come back to the Community Forum if you have anymore questions, we are more than happy to assist.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.

 

Related content