Unable to Export Reports to Excel

[ANCCranes]

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]

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]

Hi,

We are using MYOB Account Right. 

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

[Genreve_S]

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]

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]

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]

I do not have access to the hyperlink.

Can you please just provide the steps?

[Genreve_S]

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:

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]

Please find attached

[Genreve_S · Accepted solution]

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