Forum Discussion

AmandaLR's avatar
AmandaLR
Contributing User
1 month 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
1 month 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
    1 month 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

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