Error -
C:\users\username\documents\MYOB\accountright\2014
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