Forum Discussion

JenDPT's avatar
JenDPT
Experienced User
1 month 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 month 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

Brindly's avatar
Brindly
Experienced User
3 days ago

hi

myob reports are not exporting to excel

error message

please assist.

 

 

Genreve_S's avatar
Genreve_S
MYOB Moderator
3 days ago

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

Looking for something else?

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

Community home