Myob Accountright 2014.2 Error exporting Report to Excel - error TRIBAL.xlt

Here is a common error people are running into when trying to export reports in Myob Accountright 2014.2 to Excel , PDF seems to be fine.

Error -
C:\users\username\documents\MYOB\accountright\2014.2\reports\spreadsheet\TRIBAL.xlt


The issue arises when the 2014.2 installation for whatever reason fails to install the report excel templates into the directory

c:\Users\Public\Documents\MYOB\AccountRight\2014.2\Reports\Spreadsheet

Most likely this folder will be empty, it should not be

Solution

Copy the template files (.xlt) from another version of myob on your computer or install 2014.1 and copy from there e.g 2013.5 will also work

c:\Users\Public\Documents\MYOB\AccountRight\2013.5\AU\Reports\Spreadsheet

copy everything in the above directory into the 2014.2 path

That should be it, if you are super unlucky you may see the error below

Error - Exception from HRESULT: 0x800AC472

I got past this error by reinstalling myob, it seems to be some sort of error between Microsoft excel and myob communicating. hope that helped