Forum Discussion

AmandaLR's avatar
AmandaLR
Contributing User
3 months ago

Cannot export my reports to Excel

Hi In the last couple of weeks our excel security policies have changed and I now cannot export reports to excel as I get an error code coming up saying that "MYOB is attempting to open file type ex...
Genreve_S's avatar
Genreve_S
MYOB Moderator
3 months ago

Hi AmandaLR, 

 

This one’s basically your new security settings bumping heads with some older Excel formats that AccountRight still uses (like .xlt/.xls).

Could you get your IT team to check Excel’s Trust Center settings:

  • Open Excel
  • Go to File → Options → Trust Center → Trust Center Settings

If they’re not allowed to relax those settings for the older Excel formats, the only other option for now is:

  • Export the report from MYOB as CSV or TXT, then
  • Open that file in Excel – you’ll get all the data, just without the fancy formatting.

At the moment, those are the two realistic options while AccountRight catches up with Microsoft’s newer Excel policies.

 

Regards,
Genreve 

 

 

AmandaLR's avatar
AmandaLR
Contributing User
3 months ago

Okay, thanks for that.  WE cannot relax the security policy so I will go with CSV or TXT.

Looking for something else?

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

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

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