Payroll activity will not export to Excel

Highlighted
Experienced Cover User Helen_01
41 Posts
Experienced Cover User
Australia
Experienced Cover User

41Posts

6Kudos

0Solutions

Solved: Go to Solution

Payroll activity will not export to Excel

Hi all

My payroll activity for Sept 2019 will not export to excel.

I cannot send it by email, for obvious security reasons.

I have applied no filters other than month, it just comes up with the path, under the error message, but does not tranpose.

I hoping MYOB is working on this and it will be functional soon?

2 REPLIES 2
MYOB Moderator Steven_M
33,042 Posts
MYOB Moderator
New Zealand
MYOB Moderator

33,042Posts

4,413Kudos

4,789Solutions

Accepted Solution Solved

Re: Payroll activity will not export to Excel

Hi @Helen_01 

 

When you say you are getting an error is the error message similar to the following?

 

Attachment.PNG

 

If so, when you export a report out to Excel the system will look for a Spreadsheet template file to populate with that data. The particular message indicates that it has not been able to find the necessary template file and thus generates an error.

 

The best solution to remedy that situation is to uninstall the version and then reinstall the product. This should hopefully add the spreadsheets back into that Spreadsheets folder so you can send that report to Excel.

 

The other solution that has been known to work, is to go into a previous version's spreadsheet folder i.e. 2019.1's and copy the spreadsheet file into the current versions spreadsheet folder. For example, in my case I am getting the message with 2019.1 but have previously had 2018.4 installed I could navigate to:

C:\Users\--username---\Documents\MYOB\AccountRight\2018.4\Reports\Spreadsheets

and copy the PAYACTSX.XTL (or just all the files) and go to the following path and paste those files in.
C:\Users\--username---\Documents\MYOB\AccountRight\2019.1\Reports\Spreadsheets

Kind regards,
Steven

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

Experienced Cover User Helen_01
41 Posts
Experienced Cover User
Australia
Experienced Cover User

41Posts

6Kudos

0Solutions

Re: Payroll activity will not export to Excel

Thank-you Steven 

 

When following your instructions, for 2019.3 I found my spreadsheet file was empty.

When I looked in 2018.4, it was also empty (but I had never used it as I am multi-currency).

So, I went to my.myob and donwloaded 2019.1. It was populated with all the files in the spreadsheets as you said. Thank-you for the very clear instructions on how to find it.

I copied and pasted into my 2019.3, and ... IT WORKS!

 

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