Unable to export reports to Excel

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
JB2201
2 Posts
Cover User
Australia
Cover User

2Posts

0Kudos

0Solutions

Solved: Go to Solution

Unable to export reports to Excel

Hi

 

We have re-installed MYOB AccounRight in a cloud environment.  I am unable to export reports to excel and am getting the following error message:

MYOB\AccountRight\2018.4\Reports\Spreadsheet\AGEDAPS.XLT

 

Can you please assist.

 

Thanks

 

JB

3 REPLIES 3
MYOB Product Team Haydes
6,211 Posts
MYOB Product Team
Australia
MYOB Product Team

6,211Posts

1,033Kudos

889Solutions

Accepted Solution Solved

Re: Unable to export reports to Excel

Hi @JB2201

 

This is looking for an XLT file to bring the information across to, that message means that it can't find the file that's needed for the export.

 

This can be fixed in 1 of 2 ways:

 

1. Copy the .XLT files from the previous version and paste it in the current versions folder:

 

This is done by going to: C:\Users\Public\Documents\MYOB\AccountRight\, then opening 2018.2 or older then the Spreadsheet folder and copy the contents here then go to the location specified and paste these there.

 

 

2. Reinstall AccountRight to put these files back in:

 

This is done by uninstalling the current software, then reinstalling. This should then put the files back in. Note that if there is any security software interfering with the installation then this could explain why the XLT files aren't showing up.

 

Here are some support notes to help:

 

Let us know how you go.



Cheers,

Hayden (Ex-Moderator)
MYOB Product Team
Experienced Cover User Chris57
11 Posts
Experienced Cover User
Australia
Experienced Cover User

11Posts

1Kudos

0Solutions

Re: Unable to export reports to Excel

cannot export into excel only recently as I worked in december but suddenly it is not working I have unstalled myob and reinstalled and repaired excel 365

Capture.PNG
MYOB Moderator Neil_M
11,807 Posts
MYOB Moderator
MYOB Moderator

11,807Posts

1,387Kudos

1,673Solutions

Re: Unable to export reports to Excel

HI @Chris57

 

Generally speaking an error like that means that either Excel hasn’t installed correctly or the Windows registry entry for Excel is incorrect and preventing the information from exporting out of AccountRight.

 

If you have reinstalled a compatible version of Excel locally on that computer then that would indicate the issue lies with the Windows Registry. As the Windows Registry is the brains of the computer, I recommend seeking some independent IT advice on how to edit the Windows Registry

Regards,
Neil

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post