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
I'm having the same issue
the option is greyed out even when my IT / Administrator logs in to my computer to change the settings they remail grey out
Can you offer any advice so I can pass it on to him
THANKS!
Hi Southern2018,
The error you’re running into is still coming from Excel’s Trust Center having a sulk. Since your IT team already can’t unblock those File Block settings for the older Excel 97–2003 format we use for exports, the best move is to have your IT reach out to Microsoft Support. This way, they can dig into why those options are locked in your environment and recommend the right tweak for your version of Office.
Cheers,
Doreen
Sorry Doreen, that is like passing the buck. Not all companies use IT teams, some of us, like many, are small businesses which was the original aim of Myob when it first began in Australia in 1991. Using a version of Excel that is over 10 years old is ridiculous, especially when MYOB constantly has updates.
As technology leaps forward, it is wise for any software platform to keep up with the changes. Updates seem redundant if it does not.
I have worked out if you have Excel open BEFORE you export the report, then the Excel exports work as per normal. I know this is not the correct option, but it works for now. Hope this helps.
So you know, This work around has worked for me but not my co-worker.
Hi Southern2018
It is unusual that the workaround didn’t resolve the issue for your colleague. In this case, I’d recommend getting in touch with our back-end team so they can investigate this further on their side.
Regards,
Earl
