Forum Discussion

chungch's avatar
chungch
Contributing User
3 years ago

Cant export report to excel

I have installed the Account Right PC Edition 2023.5 version, but when i would like to export the report to excel, it cant export. No error was shown, just that after clicking on the export to excel button, nothing is working. If I click on the Display report button, the report will show.

 

I check the forum, some of them mentioned that this issue happen because the excel or MYOB is not the latest version but I am using the latest MYOB client version and Excel is using office 365 also the latest version.

 

Anyone can help with this ?

4 Replies

Replies have been turned off for this discussion
  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    3 years ago

    Hi chungch 

     

    Thanks for your post.

     

    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 yes, 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 let me know how it goes.

     

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

     

    Best regards,
    Doreen

  • Doreen_P's avatar
    Doreen_P
    MYOB Moderator
    3 years ago

    Hi chungch 

     

    Thanks for these details.

     

    Upon checking the error log you attached, I can see that you are experiencing the error Microsoft.Office.Interop.Excel.

     

    This type of error can be fixed by one one of the following:
     

    Please let me know how it goes.

     

    Best regards,

    Doreen

  • chungch's avatar
    chungch
    Contributing User
    3 years ago

    I found a solution. I copy the all MYOB related file from the working pc and paste it to this problem pc. After that, i generate the excel and it works.