Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Error 31: SE_ERR_NOASSOC when opening payroll reports in Excel

When attempting to open payroll reports in Excel (such as Summarize Payroll Data in Excel), you see Error 31: SE_ERR_NOASSOC.

How to fix it

This error can also occur due to QuickBooks payroll report templates not having an Excel association.

To set the file association manually:

  1. Using Windows explorer, navigate to the template through the file path listed within the error message.
  2. Double click on the file listed within the error message, and you will receive a prompt asking to select a program to associate the file to.
  3. Highlight Excel and Select OK to associate the template with Excel and open the report.
    • If needed, please refer to this Microsoft Support article for further detail regarding File Associations.

These errors can also be caused by a damaged Microsoft Office installation.  If the above steps do not resolve the issue, please see the Repair or reinstall Microsoft Office products article for steps to repair Office.



KB ID# SLN74843
10/27/2016 7:50:06 AM
QYPPRDQBKSWS09 9138 Pro 2017 1042e4