nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Can't export report to Excel file

JenDPT

Hi there

I am trying to export several different reports (P&L Budget Analysis, Bank Register, etc) to excel, but keep getting the error report.

Can anyone help, please....

Thanks

Find more posts tagged with

Accepted answers

JenDPT

Just a note for anyone else who reads this..... when I logged into MYOB this morning, there was an update and the reports are now exporting to excel.

Thanks

All comments

Brindly

Thanks Princess. I'll give it go with the online MYOB.

Our system does not allow the older version of Microsoft. I've been trying to get the older version unblocked from the 'trust center' of excel options with our IT.

Brindly

are we able to export excel reports in up to date format?

systems do not allow outdated excel formats for security reasons.

Genreve_S

Hi @Brindly,

Thanks for sharing the screenshot. I can see that the Microsoft Excel error is hindering you from exporting your reports.

That message means Excel is blocking the older template used when AccountRight exports reports.

Please try the following in Excel:

Go to File > Options > Trust Center > Trust Center Settings.
Select File Block Settings and find Excel 97-2003 Workbooks and Templates.
Make sure this file type isn't blocked, then select OK.
If the export still doesn't work, go to Trusted Locations, select Add new location, and add: Documents\MYOB\AccountRight\Current\Reports\Spreadsheet

Close and reopen Excel and AccountRight, then try exporting the report again. As this changes Excel security settings, you may need to check with your IT professional first.

For Microsoft’s instructions, see What is File Block? and Add, remove, or change a trusted location in Microsoft Office.

Regards,
Genreve

Brindly

myob reports are not exporting to excel

error message

please assist.

JenDPT

Just a note for anyone else who reads this..... when I logged into MYOB this morning, there was an update and the reports are now exporting to excel.

Thanks

JenDPT

Hi Adrian.

Thank you for your help.

I have done as suggested, and reports are still not exporting to excel.

I have 2 queries, please:

1. You did say "It’s also worth checking that PLBA.XLT exists in that folder."

Which folder did you mean for me to look into, please.

2. Because we use AccountRight online, I'm not sure of the process to reinstall AccountRight onto my laptop.

Thank you for your help.

SupportNoteGuy

Hi @JenDPT - thanks for the question.

The error message is pointing to AccountRight’s Excel template file, PLBA.XLT, rather than the report itself. As PDF export is working, this may be related to Excel blocking the older template file.

Could you try the following?

Open Excel and go to File > Options > Trust Center > Trust Center Settings > File Block Settings.
Make sure Excel 97-2003 Workbooks and Templates isn’t selected to be blocked.
If the issue continues, go to Trusted Locations in Trust Center Settings, select Add new location, and add: C:\Users\Public\Documents\MYOB\AccountRight\Current\Reports\Spreadsheet
Close Excel completely, then try exporting the report from AccountRight again. If Excel is still running in the background, end any remaining Excel task in Task Manager first.

It’s also worth checking that PLBA.XLT exists in that folder. If it’s missing, the AccountRight report templates may need to be restored by repairing or reinstalling AccountRight.

I hope this helps!

Adrian