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 ...
Forum Discussion
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
Hi Earl
We have encountered this issue as well - cannot export to Excel. We discovered a work around that MYOB will export if you have a blank Excel file open when trying to export.
However, we have also noticed that the web version does not encounter this issue as it has obviously been updated to export in the modern version of excel. When will MYOB be updating the desk top version?
Hi MargB,
Appreciate you sharing that workaround. That's actually a clever find. You're spot on too, the browser version's had a few upgrades, while the desktop version can still be a bit old-school in that space. At this stage, we don't have a specific timeframe on when the desktop export will be brought in line. In the meantime, your workaround is a solid one, and using the browser version for exports is a great shout as well.
Regards,
Sai
