Forum Discussion

pklove's avatar
2 years ago
Solved

Error exporting to excel

I'm getting an error when I try and export any report to excel.

 

The error meesage "Retrieving the COM class factory ... Server execution failed ...." is shown on the attached screenshot.

  • Ah, turns out it was a problem with Excel.

     

    I don't usually use Excel and didn't realise AccountRight relied on it.

     

    Got Excel working and now the AccountRight export is working.

     

6 Replies

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    2 years ago

    Hi pklove,

     

    Welcome to the Community Forum. 

     

    We appreciate the screenshot you've attached. However, with the current information it's hard to draw a conclusion on the cause of the issue. May I get you to send us a copy of the latest diagnostic log of your AccountRight to help understand the issue? 

     

    We look forward to your response.

     

    Thanks,
    Genreve

     

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    2 years ago

    Hi pklove

     

    Thanks for your quick response and for providing the diagnostic log of your AccountRight. You're really on the ball!

     

    I've found a forum post that might just be the treasure map you need. Other users who encountered the same issue found it quite helpful. Here's the link to the post: https://community.myob.com/t5/AccountRight-Getting-Started/Unable-to-open-recently-upgraded-company-file/td-p/718667.

     

    Give it a read and see if it helps you navigate through your issue. Remember, we're here if you need any more assistance.

     

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

     

    Thanks,
    Genreve

  • pklove's avatar
    pklove
    2 years ago

    Hi Genreve,

     

    Thanks for pointing to that, but I don't think its relevant.  

     

    My file is online and that post says tis for offline files.   It also says the diagnostic log would contain "InvalidFingerprint", which my log does not.

     

     

  • Ah, turns out it was a problem with Excel.

     

    I don't usually use Excel and didn't realise AccountRight relied on it.

     

    Got Excel working and now the AccountRight export is working.

     

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    Hi pklove,

     

    Thank you for the update!

     

    I'm glad to hear that you've managed to resolve the issue with Excel and AccountRight export. It's true that AccountRight relies on Excel for some of its functions, so having Excel working properly is crucial. I'll now close this post as resolved. If you encounter any similar issues in the future, please feel free to post again. 

     

    Cheers,

    Princess