Forum Discussion

6203's avatar
6203
Experienced Cover User
3 years ago
Solved

Can't export reports to Excel

I am using AccountRight Plus AU 2022.11.0, on my desktop.   I cannot export my reports to Excel.   Any suggestions?  (Seems to be a fairly recent problem, as I could export not that long ago.)  ...
  • Melisa_D's avatar
    Melisa_D
    3 years ago

    Hi 6203, 

     

    Looking at the error log I can see that you are experiencing the Microsoft.Office.Interop.Excel._Application error. 

     

    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
3 years ago

Hi 6203, 

 

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.

KB1971's avatar
KB1971
Experienced Cover User
2 years ago

Hi, we have recently moved to Office 365 and I am having the same problem. I cannot export to XLS.

My log is below. 

I access my file online, and had no problems with this last week, until the Office 365 migration.

I have uninstalled and reinstalled AccountRight as per your advice to other user, but am still having the same problem.

Please advise what to do now!  

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 years ago

    Hi KB1971 , check these things:

    - Is your version of Office 32 bit? AccountRight cannot export to the 64 bit version.

    - After installing Office, have you reinstalled AccountRight? AccountRight should be the last program installed.

    - If yes to the above, then try a quick repair of Office. (Go to Control Panel, Programs and features, sort by installed date, select MS 365, select Change, follow the prompts to quick repair). Then open AccountRight again and try the export. 

    • KB1971's avatar
      KB1971
      Experienced Cover User
      2 years ago

      It is 64 bit, with Windows 10 Pro. I uninstalled AccountRight, then I went to MYOB and I re-downloaded the whole application. No idea what to do next! 

      It worked previously, it's only since they installed Office 365 this week that I have suddenly got an issue.

Looking for something else?

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

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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