Excel reports

[SallyCampbell]

I am using MYOB account right 2021.4.0. I am unable to export reports to ecel and keep getting an error message, 

\Reports\Spreaadsheet\PL.XLT. I have looked up the the community page which talks about pasting reports from an old myob which I don't understand. Do I need to reinstall the software. It seems this is a common glitch.

Regards

Sally Campbell 

[Yanike_S · Accepted solution]

Hi @SallyCampbell 

Thanks for your post.

When you install AccountRight the installer will install a series of Excel Template files to be used when sending reports to Excel. In your case, it appears that the installer hasn't installed those templates, thus you are encountering an error when sending to Excel.

Is the file in the specified folder? In that case you should check your permission or security as this might be blocking access.

If the file is not in the folder location specified in the error message, I would recommend reinstalling AccountRight software, making sure the anti-virus software is disabled and running the installer as administrator (right-clicking on the installer file, and selecting the option to 'Run as Admin').

If you don't want to reinstall AccountRight, I would recommend following the process below that can be used to take the templates from a previous version and move these into your templates folder to likely resolve that situation. Note: It does assume that you have had a previous version of the AccountRight 20xx product range installed.

1. Ensure that AccountRight is closed
2. Within Windows Explorer, navigate to the following path:
   C:\Users\---username--\Documents\MYOB\AccountRight\20xx.x
   Username being the username that you use to log into Windows with and 20xx.x being a previously installed version
3. Take a copy of the Reports folder
4. Navigate to C:\Users\---username--\Documents\MYOB\AccountRight\Current
5. Paste that Reports folder inside that Current folder

The above process will take the Reports folder, the one that does contain the spreadsheets from a previous version, and then move it into where the AccountRight 2020.4.1 version is looking for them. By doing that as it is able to locate those spreadsheet files you would be able to send to Excel without that message appearing.

Let me know how you get on with this.