Can not export reports to Excel

Question

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 file block settings in the Trust Center"

How can we fix this? Our IT department are saying that it is due to Microsoft's security update and that MYOB generates a legacy xls format that is over 10 years old and the security update is now blocking these formats.

Will this be fixed in an upcoming update? Or is there a work around other than a CSV file?

earl_hd · Answer

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.&nbsp;
&nbsp;
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:&nbsp;Unable to export excel files
Cannot export my reports to ExcelRegards,Earl

Forum Discussion

Can not export reports to Excel

1 Reply

Looking for something else?

Related content

Can't export reports to Excel

Unable to Export Reports to Excel

Export Reports to Excel

Exporting reports to excel

Can't export reports to Excel

AccountRight not exporting to Excel

Exporting Reports to Excel

Excel report export