Forum Discussion

ANCCranes's avatar
ANCCranes
Contributing User
8 months ago
Solved

Unable to Export Reports to Excel

Hi

Since the last MYOB update I have been unable to export my MYOB reports to excel.

Microsoft doesn't have any updates available.

Being able to export to Excel is a crucial part of our business.

Has any one experienced this recently? Is there a work around?

We can export to pdf but not excel.

 

Your assistance would be greatly appreciated.

 

  • Genreve_S's avatar
    Genreve_S
    8 months ago

    Hi ANCCranes,

     

    Thanks for your response and the diagnostic log. 

     

    I checked on this and I found some errors on how Excel is communicating with AccountRight. 

     

    I would suggest downloading Quick Repair Office from the Microsoft website and running it to fix the issue with Excel. If this does not solve the issue, we will need an IT person to re-register the DLL files for Excel and/or check the registry values of the computer for Excel. Here is a link that might help the IT personnel in fixing the issue https://webmakers.co.nz/interface-not-registered-exception-from-hresult-0x80040155-microsoft-office-outlook-error/. 

     

    Let us know if you still need any other assistance. We're happy to help. 

     

    Cheers, 

    Genreve

15 Replies

Sort By
  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    8 months ago

    Hi ANCCranes,

     

    Thanks for posting and welcome to the Community Forum. 

     

    I'm sorry to hear about your issues exporting to Excel. Judging from the board the post is on, I believe we are using MYOB Business. Generally, MYOB Business does not have issues with transferring data from Excel because it produces a file instead of opening Excel immediately with the values. May I know if there are any error messages while opening the exported xlsx file?

     

    If my understanding is incorrect, feel free to clarify your issue. Also, any screenshots regarding this would be much appreciated.

     

    Cheers, 

    Genreve

    • ANCCranes's avatar
      ANCCranes
      Contributing User
      8 months ago

      Hi,

       

      We are using MYOB Account Right. 

       

      There is no error or code. It just simply spins (thinks) and then does nothing.

      • Genreve_S's avatar
        Genreve_S
        MYOB Moderator
        8 months ago

        Hi ANCCranes, 

         

        Thanks for clarifying the concern. 

         

        I would suggest clearing the cache of AccountRight first. Here are the steps. 

        1. Click the windows button + R. 
        2. Type in %localappdata%/myob and click okay.
        3. From the folders open AccountRight > Current > Cache. 
        4. Deleted all files in this folder.

        If the issue persists after clearing the cache, please send me your diagnostic log. Also, I would appreciate it if you could tell me what version of Excel you are using. 

         

        We look forward to your response. 

         

        Cheers, 
        Genreve

  • Sandyw1's avatar
    Sandyw1
    User
    7 months ago

    I am having the same issue .- I get an error message  with 80080005- i can successfully export PDF 

    • Celia_B's avatar
      Celia_B
      MYOB Moderator
      7 months ago

      Hi Sandyw1,

       

      Thank you for your post and welcome to the Community Forum. 

       

      I understand that you have the error message 80080005 but you can successfully export PDF. Generally, this error message means Server Execution failed, and this is caused when you lack permission to access or change certain files in the system volume information directory. Can you please confirm, did you received this error message when sending emails? If yes, "Send via Outlook 2013 and above" option is selected when using an earlier version of Outlook. To fix the issue, use the "Send via email software" option in the Email settings. 

       

      If the issue persists, kindly check your inbox to ask for some information and screenshot of the error message so we can investigate further. 

       

      If you need further assistance with this, please feel free to post again. 

       

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

       

      Thanks, 

      Cel

       

    • Celia_B's avatar
      Celia_B
      MYOB Moderator
      7 months ago

      Hi Sandyw1,

       

      I hope this message finds you well. I would just like to check back with you regarding your concern. Please let me know if you still need assistance with this. I'd be more than happy to help.

       

      Thanks, 

      Cel

       

    • Celia_B's avatar
      Celia_B
      MYOB Moderator
      7 months ago

      Hi Sandyw1,

       

      Please be informed that we will be closing the thread now. Feel free to create a new post if you have other questions or concerns. We are happy to help. 

       

      Kind Regards, 

      Cel