Partner Zone

Unable to Export Reports to Excel

ANCCranes
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

Solved: Go to Solution

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.

 

15 REPLIES 15
Genreve_S
MYOB Moderator
2,475 Posts
MYOB Moderator
MYOB Moderator

2,475Posts

68Kudos

304Solutions

Re: Unable to Export Reports to Excel

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
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

Re: Unable to Export Reports to Excel

Hi,

 

We are using MYOB Account Right. 

 

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

Genreve_S
MYOB Moderator
2,475 Posts
MYOB Moderator
MYOB Moderator

2,475Posts

68Kudos

304Solutions

Re: Unable to Export Reports to Excel

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

ANCCranes
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

Re: Unable to Export Reports to Excel

I have cleared the Cache, restarted the computer. I still have the same issue.

 

We use Microsoft 365 - version 2308 Build 16731.20234

 

We have only had this issue for approx 2 weeks. I was hoping it was a glitch that would be fixed in an update. Our other PC runs Windows 11 and has the same issue.

 

There is no error codes. It just does nothing. Where would i find/how do i get a Diagnostic Log?

Genreve_S
MYOB Moderator
2,475 Posts
MYOB Moderator
MYOB Moderator

2,475Posts

68Kudos

304Solutions

Re: Unable to Export Reports to Excel

Hi @ANCCranes

 

Thanks for the information. 

 

I'm sorry if I have not elaborated on my previous reply. I attached a hyperlink for the instructions for the diagnostic log. Here is the content of the hyperlink for the instructions to get the diagnostic log https://community.myob.com/t5/Moderators-discussion/AccountRight-Diagnostic-Log/m-p/719696.

 

We appreciate your patience, and we look forward to your reply. 

 

Cheers, 

Genreve

ANCCranes
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

Re: Unable to Export Reports to Excel

I do not have access to the hyperlink.

 

Can you please just provide the steps?

 

 

Screenshot 2023-09-15 143612.png
Genreve_S
MYOB Moderator
2,475 Posts
MYOB Moderator
MYOB Moderator

2,475Posts

68Kudos

304Solutions

Re: Unable to Export Reports to Excel

Hi @ANCCranes

 

Thank you for the response. 

 

Here are the steps from the post. 

To find the diagnostic log file:

1. Open your Start Menu
2. Type: %localappdata%
3. Open the %localappdata% folder:
temp.png
4. Open the MYOB Folder.
5. Open the AccountRight Folder.
6. Open the Current folder

Note: versions prior to 2021.1 will show as the version number, eg, 2020.2
7. Open the Diagnostics Folder.


The diagnostic file name would have the format: Huxley.Application_<<full version number>>.log 
For example, AccountRight 2021.7's diagnostic file would be Huxley.Application_2021.7.24.5180.log

 

Feel free to attach the diagnostic log to your next reply. 

 

Cheers, 

Genreve

ANCCranes
Contributing User
5 Posts
Contributing User
Contributing User

5Posts

4Kudos

0Solutions

Re: Unable to Export Reports to Excel

Please find attached

Genreve_S
MYOB Moderator
2,475 Posts
MYOB Moderator
MYOB Moderator

2,475Posts

68Kudos

304Solutions

Accepted Solution Solved

Re: Unable to Export Reports to Excel

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-... 

 

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

 

Cheers, 

Genreve

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post