ERROR: 'Failed to connect to Excel' when sending data to Excel
Description

This message can occur because:

  • You're not running Sage 50 Accounts as an administrator
  • You're not using a compatible version of Microsoft Excel
  • There's an issue with your installation of Microsoft Office
Cause
Resolution

Run Sage 50 Accounts as an administrator

Right-click the Sage 50 Accounts shortcut and select Run as administrator

If this resolved the issue, you must speak with your local IT support to change your Windows access rights.


Check that your Microsoft Office is compatible

  1. Open Sage 50 Accounts, on the menu bar select Help, then press About.
  2. Under Program Details, note the version number.
  3. Check whether your version of Microsoft Office is compatible with Sage 50 Accounts using our compatibility guide.

Manually register Microsoft Excel

  1. Close Sage 50 Accounts, then press the Windows key + R.
  2. Enter one of the following commands exactly as shown, including /regserver at the end, with the space beforehand:

    • 32bit Excel - "C:\Program Files (x86)\Microsoft Office\root\Office16\Excel.exe" /regserver
    • 64bit Excel - "C:\Program Files\Microsoft Office\root\Office16\Excel.exe" /regserver

      NOTE:

      If you’re using Excel 2013 change the 'Office16' to Office15.

       
  3. Then press OK.

If the issue continues after registering excel.exe, you first go ahead and uninstall and reinstall Microsoft Office. Then completely uninstall Sage 50 Accounts and reinstall it.

If you need any more help reinstalling Microsoft Office, refer to your local IT administrator.

TIP:

This issue has also been resolved by using the "Quick Repair" function in the Microsoft office. Open Microsoft's Repair article >

 

 

[BCB:19:UK - Sales message :ECB]





Steps to duplicate
Related Solutions