Forum Discussion

Michel-lci's avatar
Michel-lci
Experienced User
4 years ago

Export to Excel doesn't work

Hi   I am using AccountRight Plus Au 2021.4.0 and Office 365 on Windows 10 Pro.   When I try to export a MYOB report to Excel, nothing happens.  I do not get an error message, simply nothing at a...
  • Melisa_D's avatar
    Melisa_D
    4 years ago

    Hi Michel-lci, 

     

    Thank you for attaching that. By looking at the error log it looks like you're experiencing a Microsoft.Office.Interop.Excel._Application error when connecting to Microsoft applications. 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:

    Do let u know how you go.

MBLegADL's avatar
MBLegADL
Experienced Cover User
4 years ago

Having the same issue.  BAck in office yesterday after WFH - just went to export to excel and nothing!!

Seriously the timing could not be worse - how many other companies are going through audit, finalising eofy etc.. and now MYOB does this.. 

The fault with ETP screwing up in STP was enough... but MYOB you are killing me atm..

Did as others have indicated - sometimes you have to locate and copy all the spreadsheet files as on some updates this was an issue.. 

WHY all of a sudden with 2021.4 has this now screwed up?? and it's not liek we have a choice to upgrade or not since you now decide when the update happens.

this is atrocious.

  • Melisa_D's avatar
    Melisa_D
    Former Staff
    4 years ago

    Hi MBLegADL, 

     

    The error log you've provided indicates that a folder is missing from the Spreadsheet folder when trying to export to excel, 'C:\Users\Public\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet\PAYSUM.XLT'
    this can generally be resolved by uninstalling and reinstalling AccountRight.
    • MBLegADL's avatar
      MBLegADL
      Experienced Cover User
      4 years ago

      Thanks,

      Or a lot easier - now that you gave me where MYOB is looking for this version - I just copied and pasted the files from the previous version that were in a different location.

      Sorted.

      It would have been helpful to know that this upgrade was going to have a new location for these files. 

      Cheers...

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.