Forum Discussion

JenSta2's avatar
JenSta2
Member
5 hours ago

Can not export reports to Excel

We can no longer export our reports to excel as we are getting an error message stating  "you are attempting to open a file type (Excel97-2003 Workbooks and Templates) that has been blocked by your ...
Earl_HD's avatar
Earl_HD
MYOB Moderator
4 hours ago

Hi JenSta2,

Appreciate for providing the error. What your IT team is saying is spot on: AccountRight currently exports reports in the older Excel 97–2003 format (.xls / .xlt) and a recent Microsoft/Office security change is now blocking those legacy formats via the Excel Trust Center. 

 

Check Excel File Block settings (IT often needs to do this)
In Excel on one of the affected PCs:

  • Go to File → Options → Trust Center → Trust Center Settings…
  • Click File Block Settings.
  • Make sure “Excel 97–2003 Workbooks” and “Excel 97–2003 Templates” are not blocked for Open/Save (tick = blocked, clear = allowed).
  • Click OK, restart Excel, then try the export again.
  • If those options are greyed out, they’re being controlled by a group policy, so only your IT can change them

You can also visit these related Community forum posts that you may find helpful: 

Unable to export excel files

Cannot export my reports to Excel

Regards,
Earl

Looking for something else?

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

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.