Forum Discussion

GA39's avatar
GA39
Trusted User
3 years ago

Unable to export reports to Excel using AccountRight 2021.7.0

I am using AccoutRight 2021.7.0 and unable to export reports to Excel such as BS & PL. I clicked on the green Export to Excel button and nothing happens. No error message as well.

 

I have done the following and still no luck. Any other suggestions? Thanks.

 

- Right clicking on AccoutRight icon and choosing the option to Run as Administrator.
- Uninstall MYOB and reinstall the software via Run as Administrator.

  • Hi GA39

     

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

  • Hi GA39

     

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

    • GA39's avatar
      GA39
      Trusted User

      Melisa_D Thank you very much for your help!!! I used the first option to fix it and it works.

      • Melisa_D's avatar
        Melisa_D
        Former Staff

        Hi GA39

         

        You're welcome, glad to hear that's been resolved ! 

         

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