Can't export report to Excel file

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?

1. Open Excel and go to File > Options > Trust Center > Trust Center Settings > File Block Settings.
2. Make sure Excel 97-2003 Workbooks and Templates isn’t selected to be blocked.
3. 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
4. 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

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.

hi

myob reports are not exporting to excel

error message

please assist.

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:

1. Go to File > Options > Trust Center > Trust Center Settings.
2. Select File Block Settings and find Excel 97-2003 Workbooks and Templates.
3. Make sure this file type isn't blocked, then select OK.
4. 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

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

systems do not allow outdated excel formats for security reasons.

Hi Brindly,

Thanks for checking. Reports exported from the desktop version currently exports in the older .xls format by default, but you can open the file in Excel and save it as an Excel Workbook (*.xlsx) using File > Save As.

Cheers,

Princess

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.