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.