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 click 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 click Help, then click About.
  2. Under Program Details, note the version number.
  3. Use our Microsoft Office and Sage software compatibility guide to ensure your version of Microsoft Office is compatible with your Sage 50 Accounts.

Manually register Microsoft Excel

  1. Close Sage 50 Accounts, then press the Windows key + R.
  2. Enter:
    • 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 click 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