Skip to content
logo Knowledgebase

'Failed to connect to Excel' when sending data to Excel

Created on  | Last modified on 

Summary

Why this message appears when sending data to Excel from Sage 50 Accounts, and how to resolve it.

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

Let's fix this now.

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 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 persists after registering excel.exe, first uninstall and reinstall Microsoft Office. Then completely uninstall Sage 50 Accounts and reinstall it.

For further assistance reinstalling Microsoft Office, refer to your local IT administrator.

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

 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Leave your details

Image