Forum Discussion

JenDPT's avatar
JenDPT
Experienced User
3 days ago
Solved

Can't export report to Excel file

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
  • JenDPT's avatar
    JenDPT
    1 day ago

    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

SupportNoteGuy's avatar
SupportNoteGuy
MYOB Staff
3 days ago

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

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home