Forum Discussion

ANCCranes's avatar
ANCCranes
Contributing User
2 years 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.

 

  • 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

18 Replies

  • 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 Staff
    2 years 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

     

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    1 year ago

    Hi DejongHoists

     

    Thank you for sharing your concern on this platform and for providing the diagnostic log in your post. I apologize for the delay in my response.

     

    I responded to your private message before realizing you had attached the diagnostic log here in this thread. Upon reviewing the log, it appears to display the same error as ANCCranes' issue in this thread. I would suggest following the instructions provided in this forum thread.

     

    Should you need further assistance, please feel free to reach out. We're here to support you.

     

    Thanks,
    Genreve

  • VW1's avatar
    VW1
    Contributing User
    1 year ago

    Hello,

    I have exactly the same issue as ANCCranes. No error message. Excel is green, not greyed out & all other options PDF etc work fine. I have recently set up a new computer on windows 11. My old computer is on windows 10. I have exactly the same programs on both computers. The old one works fine & I have checked lots of settings to see if anything is different between them but everything is set up the same. I have uninstalled & reinstalled both MYOB Accountright to no avail. Any other suggestions that I could try? Thankyou Veronica

  • I have found a resolution to this issue of not being able to export to excel from MYOB accounts right on the desktop.  The application will only run on 32bit Microsoft Office and not 64 bit.  Simply uninstall office 64bit and install 32 bit.  This is a glitch and software development issue that MYOB needs to address asap.  

    All the solutions in this thread did not assist me.  

  • VW1's avatar
    VW1
    Contributing User
    1 year ago

    Thanks JK6. Unfortunately this didn't work for me. But at least now I have an error coming up whereas before there was just nothing. No it just says Error C:/users/public/documents/MYOB/accountright/current/reports/spreadsheet/PAYACTSX.XLT When I follow that path there is nothing there. Is there perhaps a missing file I need to download from somewhere? Any help would be greatly appreciated as I've tried all other suggestions.

  • CYClovelly's avatar
    CYClovelly
    Member
    1 year ago

    Hi Genreve, 

     

    I have had the above error message when export reports to excel. 

    Can you please advise how to get the excel report working? I have tried deleting the cache, but the error message still shows. 

     

    Best regards, 

    Catherine